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

I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,

3 Answers   CSC,

What is Data Caches size?

0 Answers   Informatica,

can we generate reports in informatica ? How?

3 Answers  

how to call lookup qualifer in unconnected look;up

1 Answers   BirlaSoft,

Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it

1 Answers  

Difference between Data and Index Caches?

0 Answers   Informatica,

what are surrogate keys?

5 Answers  

hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.

10 Answers  

explain about informatica server architecture?

1 Answers   IBM,

why we use datawarehouse

0 Answers   HCL,

What is workflow manager?

0 Answers  

Which means the first record should come as last record and last record should come as first record and load into the target file?

0 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories