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

WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD

8 Answers   L&T,

project Steps,hits, Project level HArd things,Solved methods?

0 Answers   Hexaware,

how many datamarts we will use in real time project and when will use the datamart?pls send the replay early

2 Answers   Tech Mahindra,

what is the diff between sequential file and fileset stages?

3 Answers  

How many types of sorting methods are available in datastage?

0 Answers  

how to transfer file from one system to another system in unix? which cmd to be use?

5 Answers   Cap Gemini,

plz tell me some dimentional and fact table names in banking project?

2 Answers   Virtusa,

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

0 Answers   IBM,

how to sort two columns in single job in datastage.

0 Answers   TCS,

How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

1 Answers   Infosys, TCS,

how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 records 1st record ie 1st column contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to get target as 2nd columns as 20,30,40 how can i?

3 Answers   Accenture,

How to remove blank spaces from data?

3 Answers  

For more Data Stage Interview Questions Click Here
Categories