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
8814 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

More Data Stage Interview Questions

How many areas for files does datastage have?

0 Answers

How to add zero "0" before record in a field?

4 Answers

Define meta stage?

0 Answers

What are the various kinds of containers available in datastage?

0 Answers

What is usage analysis in datastage?

0 Answers

how to capture rejected data by using join stage not for lookup stage. please let me know

3 Answers Satyam,

Hi I am Vijay In my source i've 10 records in a single column.... but i want to split those records into 5 sequential files each seq file contains 2 records.?.... can any body help me?

15 Answers Scope International,

how to handle null values in sequential file?

1 Answers HCL,

What are the types of views in datastage director?

0 Answers

How to RD using transformer?

0 Answers CTS,

if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA

2 Answers

What is "fatal error/rdbms code 3996" error?

0 Answers

For more Data Stage Interview Questions Click Here