Sign Up Login


  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

If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?

2 Answers  

Using Expression transformation how to remove duplicate records from a relational source?

4 Answers  

Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin

1 Answers  

HOW TO DELETE A RECORD FROM FLAT FILE

6 Answers   TCS,

1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.

5 Answers   CTS,




How to generate the HTML output using Informatica.

3 Answers   Wipro,

If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?

4 Answers  

what are the reusable tasks in informatica ?

11 Answers   CTS, HP, IBM, TCS,

In warehouses how many schemas are there?

0 Answers  

How u use pdf file in informatica source?

2 Answers   Ericsson, HP, IBM,

What is difference macros and prompts?

2 Answers  

Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?

4 Answers  

For more Informatica Interview Questions Click Here
Categories