DSXchange

look at the data and identify the uniquenes and compare on the key column which are present in both the files

Hi there, Whenever i am trying to run a sequence job there are parameters which i have to give and they are plenty, and i cannot hard code into these parameters or parameter sets. all i can do is write all the parameters in one notepad and copy paste eaxh and everytime i am running, the issue is som...

okay Ray thanks will consider your thoughts

I have a complex job with n number of stages, i want to keep every stage in good looking fashion or auto arrange the stages in order, just like in informatica, can we do that?

It would be great if we can have this feature......otherwise we will go crazy arranging the stages in line...

Thanks

Thanks for the sugestion will definately post in the enahancement request.

Hi There,

I have a complex job with n number of stages, i want to keep every stage in good looking fashion or auto arrange the stages in order, just like in informatica, can we do that?
I dont think so....but one of my X colleague said we can do it in datastage also.

And also one of the possible mistakes you could have done is...the INSERT/Delete/Update query...check that....thanks....FYI

Ray is absolutely correct, i was also writing to the ODBC stage, i got the same error, i applied the solution which Ray gave and it worked , it pointed me to the right stage where the error is. Error was at the odbc stage, result: ODBC_Enterprise_32,1: [DataDirect][ODBC SQL Server Driver][SQL Server...

Thanks Ray i have checked, there is data in the file.
only thing the metadata is not correct and i have recreated the table definition from scractch and it runs fine now. thanks....!

Thanks for the response...will try and post the result.

Anybody is having any idea what this error means, i have searched in the forum....it gives the same error for other source files like sequential files as well...but those solutions are not working on this. ##I IIS-DSEE-TUTL-00031 09:09:04(001) <main_program> The open files limit is 100; raising to 4...

kandyshandy wrote:It is given in the document that warning will come on certain situations with CDC usage. You need to partition/sort both input links based on keys.

i have done that already.....anyways problem is solved now i have some data issues will post it in different thread.

Yes i got the solution, by changing the change mode to "Explicit Keys, All Values" in cdc stage properties. Now it is looking for all the column's changed values. not sure how this happens...will post the answer as soon as i know. for time being i will keep it resolved.

Yes right.

Hi Dsxchangers, I am having a job where i am using two sequential files as before and after datafiles for cdc stage and then i am loading it into a target sequential file. the job runs fine but i am getting the below mentioned warnings, can anybody share some ideas about what the error is? chg_cap: ...