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
- 8889 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
Differentiate between datastage and informatica?
why do u need the IOS upgradation in a FC switch
what is repositery?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What is the difference between Datastage 7.5 and 7.0?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Describe the main features of datastage?
Define ds designer?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
How many areas for files does datastage have?
What are system variables and sequencers in datastage
Define Routines and their types?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
what is flow of project?
