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 the diff. b/w informatica versions 8.1.1 and 8.6.1?

4 Answers   IBM, Wipro,

How to partition the Session?

0 Answers   Informatica,

How to do Integration testing in Informatica?

5 Answers   Intelligroup,

Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.

0 Answers  

What are the differences between a connected lookup and unconnected lookup?

0 Answers  

When do you use sql override in a lookup transformation?

0 Answers  

what is shortcut in informatica? difference between shortcut,reusable object?

2 Answers   Virtusa,

Write the unconnected lookup syntax?

0 Answers  

If u r using dynamic cache lookup port will be thier in thet which option u will select

1 Answers   HCL,

How to convert multiple rows to single row (multiple columns) in informatica

0 Answers   Informatica,

explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???

8 Answers   CTS, TCS,

Define sessions in informatica etl?

0 Answers  

For more Informatica Interview Questions Click Here
Categories