Interested to Buy Any Domain ? << Click Here >> for more details...
how to connect two or more table with single source qualifier?
- 4 Answers
- 20952 Views
- IBM, I also Faced
- E-Mail Answers
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 |
What do you understand by term role-playing dimension?
What is aggregate awareness?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.
Enlist few areas or real-time situations where informatica is required.
What is facttable granularity?
scd methodology?
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.
performance wise which one is better in joiner and lookup transformation
Do joiner transformation use cache? If so describe?
WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com
how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.
Teradata 
