Interested to Buy Any Domain ? << Click Here >> for more details...
how to connect two or more table with single source qualifier?
- 4 Answers
- 20930 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 |
How to recover the standalone session?
Name 4 output files that informatica server creates during session running?
In which transformation you cannot drag ports into it?
how to load dimension table and fact table. plz tell me the steps.
I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...
what is shared lookup&persistent lookup?
4 Answers Accenture, Cap Gemini,
Why sorter is an active transformation?
What are the different threads in DTM process?
I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
what are the perameter and variable?
Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?
Teradata 
