I have a few records all are same structures data, I want to store data in mult

I have a few records all are same structures data, I want to
store data in multiple targets how?

Question Posted / ramesh.etl.10

4 Answers
8107 Views
Polaris, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I have a few records all are same structures data, I want to store data in multiple targets how?..

Answer / vamsi

use copy stage , drag for multiple out puts

Is This Answer Correct ?

8 Yes

0 No

I have a few records all are same structures data, I want to store data in multiple targets how?..

Answer / raman

Use the same job for loading by parameterizing the file
name the table name.

Is This Answer Correct ?

2 Yes

0 No

I have a few records all are same structures data, I want to store data in multiple targets how?..

Answer / 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

I have a few records all are same structures data, I want to store data in multiple targets how?..

Answer / srikanth

very good answer

Is This Answer Correct ?

1 Yes

1 No

Post New Answer