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 to Join Tables my Source is having 15 table target is
one?

Answers were Sorted based on User's Feedback



How to Join Tables my Source is having 15 table target is one?..

Answer / suneel kumar

First of all which type of sources yiu are using.
1)If all source types are same type of databases you can go
for joiner or SQ
2)If sources are diff types of databases u should go for joiner.

Is This Answer Correct ?    6 Yes 1 No

How to Join Tables my Source is having 15 table target is one?..

Answer / narender_kusa

if u have n sources u need n-1 joins..

Is This Answer Correct ?    4 Yes 1 No

How to Join Tables my Source is having 15 table target is one?..

Answer / moorthy g (ibm)

If your source is Flat file and Same Strcture then you can
go for indirect file type.
If source is relation file the you can use Source
Qualifier - Sql override or join condtion.
or Joiner Transformation(n-1)
=====
We Can join those tables in DB level.
(For Performance Tuning)

Is This Answer Correct ?    3 Yes 0 No

How to Join Tables my Source is having 15 table target is one?..

Answer / balu024

if you have same meta data in all 15 tables, then you can join
those tables by using union transformation

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More Informatica Interview Questions

What is Performance tuning in Informatica?

1 Answers   CTS, GE, TCS,


What are the mapings that we use for slowly changing dimension table?

2 Answers  


What is domain and gateway node?

0 Answers  


tell me 5 session failure in real time how can you solve that in your project?

0 Answers   CSC,


error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.

4 Answers  


What is tracing level and what are the types of tracing level?

2 Answers   TCS,


My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….

7 Answers   Accenture,


IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????

3 Answers   IBM,


Issue with Update override at Target table in Informatica.

2 Answers  


In a sequential batch can you run the session if previous session fails?

4 Answers  


What are the different types of olap? Give an example?

0 Answers  


How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)

5 Answers   TCS,


Categories