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

write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales

3 Answers   Cognizant, Flextronics,

what is the size of ur database(like oracle)

2 Answers   HP,

What are reusable transformations in how many ways we can create them?

2 Answers  

if i have a delimited file as source so how can we seperate this file into three diff targets?

2 Answers   TCS,

If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?

4 Answers  

HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?

11 Answers   Cap Gemini,

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

0 Answers   Cap Gemini, Cognizant,

How to elaborate powercenter integration service?

0 Answers  

Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.

5 Answers   DELL, TCS,

What are the features of complex mapping?

0 Answers  

my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?

3 Answers   ACS,

What is InformaticaPowerCenter?

0 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories