how to connect two or more table with single source qualifier?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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
What is the way to execute pl/sql script using informatica mapping?
Explian the connected and unconnected lookup transformation
Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?
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
What is a sorter transformation?
can we use cartesian join in informatica
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
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...
Using Connected or unconnected lookup for performance wise which one is preferable?.
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
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