I have a few records all are same structures data, I want to
store data in multiple targets how?
- 4 Answers
- 8167 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
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
How many types of stage?
root tree will find which is server job and which is parallel job?
What is the purpose of pivot stage?
What is the difference between an operational datastage and a data warehouse?
What a datastage macro?
how to sort two columns in single job in datastage.
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
what is the use of materialized view?
What are the types of containers in datastage?
Where do the datastage jobs get stored?
How to perform incremental load in datastage?
Difference between server jobs & parallel jobs?
Describe link sort?
Describe the architecture of datastage?
