how to connect two or more table with single source qualifier?

Answers were Sorted based on User's Feedback



how to connect two or more table with single source qualifier?..

Answer / sukanta

Drag two tables to mapping designer.Now with two tables two
source qualifier has come to the workspace among which you
delete second source's source qualifier.Now drag all ports
from 2nd source to first source qualifier.Now the first
qualifier have contained all ports of two sources.

But before than that in source analyzer you make a PK-FK
relation between two sources.Now in the source qualifier you
make a join condition upon that two port for PK-FK.

You get the solution.

Regards
Sukanta

Is This Answer Correct ?    18 Yes 1 No

how to connect two or more table with single source qualifier?..

Answer / tilak kumar dhar

We can use a Source Qualifier Transformation for this.

Perform the steps to achieve it:

1. Drag all the tables in Mapping Designer.
2. Delete all the source qualifiers associated with all the
tables.
3. Create a SQ transformation.
4. Drag all the columns from all the tables into the SQ
transformation.

Is This Answer Correct ?    5 Yes 1 No

how to connect two or more table with single source qualifier?..

Answer / kish

hi,

by using sql override....

Is This Answer Correct ?    3 Yes 1 No

how to connect two or more table with single source qualifier?..

Answer / rampriya

Create a Oracle source with how much ever column you want
and write the join query in SQL query override. But the
column order and data type should be same as in the SQL query.

Is This Answer Correct ?    1 Yes 7 No

Post New Answer

More Informatica Interview Questions

I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help

1 Answers   Axtria,


What is the way to execute pl/sql script using informatica mapping?

0 Answers  


Explian the connected and unconnected lookup transformation

1 Answers   Informatica,


Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?

5 Answers   Flextronics,


suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how

7 Answers   TCS,






What is a sorter transformation?

0 Answers   Informatica,


can we use cartesian join in informatica

3 Answers   IBM,


In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

1 Answers   Wipro,


How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

1 Answers   Cap Gemini,


Using Connected or unconnected lookup for performance wise which one is preferable?.

1 Answers   Deloitte,


How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important

4 Answers   CTS,


Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer

3 Answers   TCS,


Categories