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 |
write a query to retrieve the latest records from the table sorted by version(scd)
Suppose we do not group by on any ports of the aggregator what will be the output?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000
Can you use the maping parameters or variables created in one maping into any other reusable transformation?
what happens when a batch fails?
what is surrogate id ?
What are the reusable transformations?
please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.
How many ways are there to do 'remove duplicate records in informatica'?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?
can we send mail when ever it get success or faulure to other mailid?(Not company mail id)