Interested to Buy Any Domain ? << Click Here >> for more details...
I have a few records all are same structures data, I want to
store data in multiple targets how?
- 4 Answers
- 9016 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
Define Job control?
options available in sequence job to run,validate?
What is apt_config in datastage?
Can you explain how could anyone drop the index before loading the data in target in datastage?
What is the sortmerge collector?
What are system variables and sequencers in datastage
How the ipc stage work?
What are some prerequisites for datastage?
What is the difference between hashfile and sequential file?
What is difference between symmetric multiprocessing and massive parallel processing?
How do you import and export data into datastage?
How do you remove duplicate values in datastage?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
Explain how a source file is populated?
How do u convert the columns to rows in datastage?
