DSXchange

Thanks Ray Still I cant understand something clearly. I understood the hJob is going to be the reference and the job name should be retrieved by using hJob. Still i am getting the same result. I need to know what else i am missing. And also i wish to know, whether i need to pass just the job name / ...

why should not you try the trim founction in SQL query level itself. If needed cast it for varchar.

DS User

Hello all I written a small server job which should attach a job which ran before this job and need to check some info. I can't figure it out, why it is not attaching a job. Something I might missing will be the reason I guess. Please have look into my code. $IFNDEF JOBCONTROL.H $INCLUDE DSINCLUDE J...

Try it with odbc

if you are reading from the database!, then how many columns are you reading? what data type? Where it is coming as a 2nd row?

You dont want the reject data or reject link itself?

If you passed it to a peek stage will help you and it wont store any data physically.

DS User

Hello All Source and Target : SQL Server Data volume : 500,000 records for each run. I am working for a logic. A job reads the data from source SQL Server and do full outer join and apply some logic in TFM and finally load into the target table, if the data succeed in the validation. If TFM passes (...

Senior only proposed this approach. The bad thing is whenever new person come to board, they are not trying to find what we have and what should be done to improve. Instead of that , they want to change the entire approach as per their experience / what they know. They are going to link the server a...

Thanks for the response.

Just we are migrating it to 8.5. Is it same in 8.5 / any good flexibility is there?

DS User

Datastage might be waiting to get the response might be the reason why the job was in running state. If you look into the Director, you might see the entries till orchstats: loaded OR node info. After that no entires!

The problem is with the test file you created might be the reason is my guess . Try it again with another file having multiple columns.

Set proper delimiter
Use File pattern


DS User

Thanks for the comments Ray Already we have Datastage jobs which is running good. But one of the newly joined Senior, wish to implement Stored Procedure approach which he did in his previous project. So we have to (!) find the merits and demerits of using Stored procedures and Datastage. Thanks DS U...

Hello All Just i wish to know which should be the best approach to load the data from source to target. SQL Server stored procedure / Datastage. How to compare an ETL tool with Database? I am not comparing an ETL tool with Database. But I wish to know, which would be the efficient way to achieve the...

Thanks chulett.

I did the changes and that error gone.

DS User

Hello All I am getting the below error while I run the job. XML_Input_12,0: Error: The link contains more than one repetition rule XML_Input_12,0: ?? XML_Input_12,0: Resource bundle corresponding to message key DSTAGE-TODC-00017 not found! Check that DSHOME or APT_RESPATH is set. XML_Input_12,0: The...