DSXchange

From this source file, are you just looking to build and execute a single update statement for each row - with source and target tables accessible in the same statement? Or do you need to dynamically select from one database and then dynamically update from another? I am looking for dynamically sel...

Hi, I have an requirement, i will get one csv file with the below format SrcTble SrcColum SrcColumVal TgtTble TgtColum1 TrgColumn1Val A X 1 D XX 123 B Z 3 H JJ 678 TrgColum2 TrgColum2Val YY 456 VV 000 based on the above file i need to update the target table columns dynamically becuase the table and...

Hi,

I want to get full outer join results by using three tables.

first i am trying to get full outer join results using two tables.
In the join stage out put/mapping tab it is showing left record and right record how to mapp this to get full outer join results.

Thanks in Advance!

-Vijay

I dont know which one is suitable for me weather its lookup or change capture stage.


My requirement is i need to inset the records which is not avaialable in target.

- Vijay

Hi,

I am new to datastage parallel, please let me know how to achive not(notfound(....)) results in parallel edition.

my requirement is i need to pass only new records which is not present in target.

Thanks in Advance

-Vijay

Hi,

Any one pls. help me..


-Vijay

Hi, I have a requirement i need to convert one delimited string to rows, but i am not sure how many delimiters i will get it. Eg: Input: Project ID User ID 1 31716#@#31965 2 31924#@#32677#@#31689#@#37011#@#30855#@#30096 3 3251058 4 32401#@#42862#@#32401#@#42862 Expected output is : Project ID User I...

Yes, its not triggering the script at 1.30

Hi, I have a crontab entry for my unix script, its working properly for the mins but its not working for hours what was the problem, please anyone help to reslove this. I didint get any error messages. The entries is : 30 * * * * ksh/opt/node2/data/MIS_Reporting/scripts/mis_rm_load_dev.sh this is wo...

Thanks for the reply.

Pls. any one let me know how to configure the DB2 PLUG IN.
Procedure to configure one DB2 databse to Datastage 7.5 in UNIX Server version.

Thanks in Advance

Any one Pls. me know the difference between Datastage V 7.1 and V 7.5 for server

No, only the jobs/sequence which is access the table needs to be wait.

We have a requirement like we have to update a flag before and after running our sequences Eg. The table structures is SeqNo TableName Result 1 P1 50 ( If the result is 50 we will start our jobs and the run time we will update this table is 10 at that time other dependency jobs wont run) 2 P1 10 ( a...

We have a requirement like we have to update a flag before and after running our sequences Eg. The table structures is SeqNo TableName Result 1 P1 50 ( If the result is 50 we will start our jobs and the run time we will update this table is 10 at that time other dependency jobs wont run) 2 P1 10 ( a...