DSXchange

Why not simply read the documentation for that stage?

pandeesh wrote:Don't feel that i am hijacking the thread. I am trying to provide the proper solution for badra(the same issue i have faced earlier).

I know, I know... just your normal hijacky way of helping out.

We know, you already posted that in your other post. In your shoes, I would take that question to your official support provider.

So, do you have the NLS mismatch as noted? If version 8.5 is installed with NLS option and version 7.5 is not, then run ds_nls_run_off.bat in the specific project folder, and then re-run ds_nls_on.bat in the specific project folder to resolve the issue. Just to be anal and depending on how you searc...

Also be more careful with your variable names, "valid" and "Valid" are two different variables.

mdbatra wrote:Is there any way in BASIC to fetch the log based on the start and end time ?

From what I recall the answer is yes, but I don't have my documention handy to check at this moment.

The lesson to take away from this is to first check to see if your string is valid and then convert it only if it is in fact valid. Converting and then checking is too late.

Many times problems or loopholes are corrected in an upgrade and things that people thought were 'working fine' no longer do, meaning they never really worked properly in the first place. ps. Next time, post once in the proper forum rather than repeating your post in multiple forums. I removed the o...

The LONG datatype has never been supported. They are painful to work with in SQL, never mind an ETL tool.

If you literally mean a constraint, that won't affect your Oracle data being sourced. You'd need to use the date in the where clause in order to leverage your index and only source the appropriate records.

The only way to know would be to open a support case. If you are seeing this behaviour across multiple jobs (rather than just a specific one) then that would be the next step that I would suggest.

Yes, so you'll need to get a handle to that other job and use that rather than DSJ.ME and release it when you are done.

So, out of curiousity, do you actually do validation runs or is this mostly just an academic question?

The question is quite clear, however I for one don't have an answer. If you've found that checking the interim status doesn't differentiate between those two end states, I'm not sure how else you would go about it. Not saying it can't be done, just that off the top of my head I don't know how. Never...

chetan.c wrote:Trying to have a better understanding of stage variables so asked.

No worries, just wanted to make sure there wasn't an actual problem lurking under there.