Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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

Question Posted / ramesh.etl.10

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

Define Data Stage?

0 Answers  

how to sort two columns in single job in datastage.

1 Answers   TCS,

Triggers,VIEW,Procedures

0 Answers   CTS,

i have the source from Uk,north america how can i pass the data two tables based on the locations

2 Answers  

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

0 Answers  

how to configure databases through datastage

2 Answers  

What are the repository tables in datastage?

0 Answers  

Explain the situation where you have applied SCD in your project?

0 Answers  

how to add a new records into source?

0 Answers  

Define Merge?

0 Answers  

How will you move hashed file from one location to another location?

0 Answers   NTT Data,

What is the project in datastage?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories