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


How do you load 10 different sources with 10 different layouts
to 10 different tables?



How do you load 10 different sources with 10 different layouts to 10 different tables?..

Answer / ankit gosain

Hi All,

Simply take 10 seqential files and map it to 10 targets in
your canvas.
like:
seq1------>tgt1

seq2------>tgt2

seq3------>tgt3

--------
--------
--------

seq10----->tgt10

and define the source and target metadeta as you do
normally. now this job independently can load 10 different
sources with 10 different targerts.

For more queries, mail me on ankitgosain@gmail.com

Cheers,
Ankit :)

Is This Answer Correct ?    3 Yes 2 No

Post New Answer

More Data Stage Interview Questions

how can u handle null values in transformer stage.

7 Answers  


it is possible to load two tables data into one sequential file?if possible how?plz share with me?

6 Answers   TCS,


Differentiate between data file and descriptor file?

0 Answers  


How do you run datastage job from the command line?

0 Answers  


1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

0 Answers   IBM,


What are the functionalities of link collector?

0 Answers  


What are some prerequisites for datastage?

0 Answers  


Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 reddy could u please help in this Thanks in advance.

6 Answers   Teradata,


I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on

1 Answers   Accenture,


What is meta stage?

0 Answers  


what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none

1 Answers   Wipro,


What is the diff between sort performed at sort stage and the stream sort performed at the input of few stages in DS Enterprise edition?

1 Answers  


Categories