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
- 8694 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
How many types of hash files are there?
If you want to use the same piece of code in different jobs, how will you achieve it?
Highlight the main features of datastage?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
I have a few records just I want to store data in to targets cycling way how?
What is a datastage job?
what is repositery?
Name the different sorting methods in datastage.
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
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What is the difference between hashfile and sequential file?
How to RD using transformer?
How you can fix the truncated data error in datastage?
how to delete one row in target dataset
