I have a few records all are same structures data, I want to
store data in multiple targets how?
Answer Posted / geetha
Use transformer stage and modulus function. Lets say we have 4 target tables and set constraint to each target links as below.
Link1--> mod(@INROWNUM,4)=0
Link2--> mod(@INROWNUM,4)=1
Link3--> mod(@INROWNUM,4)=2
Link4--> mod(@INROWNUM,4)=3
we can also use filter stage and where clause to split the records
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are stage variables, derivations and constants?
What is the different type of jobs in datastage?
what is the use of surogate key in datastage
What is usage analysis in datastage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
If you want to use a same piece of code in different jobs, how will you achieve this?
How do you import and export data into datastage?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
How to reverse the string using SQL?
What are the partitioning techniques available in link partitioner?
What is the project in datastage?
How can you write parallel routines in datastage PX?
What is oci?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?