I have a few records all are same structures data, I want to
store data in multiple targets how?
- 4 Answers
- 7208 Views
- Polaris, I also Faced
- E-Mail Answers
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 the main features of datastage?
Can you implement SCD2 using join, transformer and funnel stage?
Difference between sequential file and data set?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Define oconv () and iconv () functions in datastage?
sed,awk,head
If you want to use the same piece of code in different jobs, how will you achieve it?
How to manage date conversion in Datastage?
Whats difference betweeen operational data stage (ods) and data warehouse?
How the ipc stage work?
How to RD using transformer?
In Datastage, how you can fix the truncated data error?
How do you remove duplicate values in datastage?
What is "fatal error/rdbms code 3996" error?
Differentiate between Join, Merge and Lookup stage?
