I have a few records all are same structures data, I want to
store data in multiple targets how?
- 4 Answers
- 8229 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
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is ibm datastage?
What is a merge in datastage?
Have you used Unstructured data?
How rejected rows are managed in datastage?
What are the types of containers?
How to implement complex jobs in data stage?
What is the difference between server job and parallel jobs?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
Can you explain how could anyone drop the index before loading the data in target in datastage?
What are stage variables?
What are the types of containers and how to create them?
If you want to use the same piece of code in different jobs, how will you achieve it?
What is the difference between datastage and informatica?
root tree will find which is server job and which is parallel job?
