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 >> Informatica
  2. Suggest New Category

i have different sources in different databases ,that
sources may be
100 tables i want to load these tables in to single target
how to
pearform the task

Question Posted / raghu

Answers were Sorted based on User's Feedback



i have different sources in different databases ,that sources may be 100 tables i want to load th..

Answer / suresh

hi rachana

if here there are 100 tables
at that time we have to use 99 joins or is there any
another process for joining the 100 tables from diff
sources into to a single target

let me know if u know the answer

thanks for u r considiration

Is This Answer Correct ?    1 Yes 2 No

i have different sources in different databases ,that sources may be 100 tables i want to load th..

Answer / rachana

Use a Joiner Transformation to join the tables and load
into single target. Joiner tarnsformation can join
heterogenous sources

Is This Answer Correct ?    0 Yes 3 No

i have different sources in different databases ,that sources may be 100 tables i want to load th..

Answer / manish

we can use different target object for the same target table
and can load the data

Is This Answer Correct ?    1 Yes 4 No

i have different sources in different databases ,that sources may be 100 tables i want to load th..

Answer / gopi krishna k

write a pre sql which joins all 100 tables
Am I right?

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More Informatica Interview Questions

How to load last n records of file into target table - informatica

0 Answers   Informatica,

we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.

8 Answers  

how DTM buffer size and buffer block size are related

3 Answers   Wipro,

can any one give some examples for pre sql and post sql(Except dropping and creating index).

0 Answers   Zensar,

two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .

2 Answers   TCS,

What are Dimensions and various types of Dimensions?

3 Answers   PayPal, TCS,

Can u generate reports in Informatica?

0 Answers   Informatica,

What are data-driven sessions?

0 Answers  

In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data

2 Answers   HCL, Schneider,

How are parameters defined in informatica?

3 Answers   HP, TCS,

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

1 Answers   TCS,

How do you do error handling in Informatica?

1 Answers  

For more Informatica Interview Questions Click Here
Categories