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

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

which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?

6 Answers   IBM,

How can i send first half of the records to one target and Remaining to other target?

10 Answers   TCS,

Performance wise which is better joiner or look up ? Give me with example?

1 Answers   CGI,

How do you update the records with or without using update strategy?

0 Answers  

how you will maintain version?

3 Answers   CTS, TCS,

What are Dimensional table?

0 Answers   Informatica,

What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

2 Answers  

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

2 Answers   Zensar,

Can we run session without using workflows?

5 Answers   TCS,

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

0 Answers  

what are the deliverables?in your project?

0 Answers   DELL,

What is the function of union transformation?

0 Answers  

For more Informatica Interview Questions Click Here
Categories