Interested to Buy Any Domain ? << Click Here >> for more details...
how to connect two or more table with single source qualifier?
- 4 Answers
- 20772 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 is polling?
Difference between Target-based loading and constraint-based loading?
what is song in infrmatica...?
What are the tasks that source qualifier performs?
What is meant by lookup transformation?
when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/
can you please explain me pre session and post session options?
If u select groupby port in aggregator what is output and dont select groupby option what is output
Write the program through which the records can be updated?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
0 Answers Cap Gemini, Cognizant,
Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V
wht target override?wht advantages it has compare to target update?
Teradata 
