Interested to Buy Any Domain ? << Click Here >> for more details...
how to connect two or more table with single source qualifier?
- 4 Answers
- 20975 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
State the limitations where we cannot use joiner in the mapping pipeline?
Explain the shared cache and re-cache?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How are the sources and targets definitions imported in informatica designer?
what is degenerated dimension?
What is an aggregator transformation?
Do you find any difficulty while working with flat files as source and target?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
pmscmd startworkflow -sv
Under which circumstances, informatica server creates reject files?
Where are the source flat files kept before running the session?
What are the components of workflow manager?
What is lookup transformation?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
