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

What is source qualifier transformation in informatica?

0 Answers  

Can you create a flatfile target

3 Answers   ABC,

I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com

119 Answers   Accenture, Gcs, TCS,

How will u pas the data with out debugger?

4 Answers  

difference between informatica 8.6 and 9

3 Answers   Atos Origin, BA Continnum Solutions, Core Logic,

how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!

3 Answers   TCS,

how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

0 Answers   Patni,

How the informatica server increases the session performance through partitioning the source?

1 Answers  

My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?

3 Answers  

Clarify the utilization of aggregator cache record?

0 Answers  

Explain what are the different versions of informatica?

0 Answers  

How can you differentiate between powercenter and power map?

0 Answers  

For more Informatica Interview Questions Click Here
Categories