1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / deva_dwh

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

Explain your project of banking domian.

0 Answers   Cap Gemini,

Differences between version 7.x and 8.x.

0 Answers   Accenture, Cognizant,

my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same

2 Answers   KPIT,

What is hash partition?

1 Answers  

If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?

1 Answers   TCS,




comonly how meny mappings r there in Banking projects?

1 Answers  

what are factless facts? And in which scenario will you use such kinds of fact tables.

0 Answers  

how to load dimension table and fact table. plz tell me the steps.

0 Answers   Cognizant, IBM,

Explain what are the different versions of informatica?

0 Answers  

Design a mapping to load a target table with the following values from the above source?

0 Answers   Informatica,

can anyone explain me about sales project in informatica?

8 Answers   MBT, Satyam,

What is a grid in Informatica?

0 Answers  

For more Informatica Interview Questions Click Here
Categories