how to join the 2 different table with different columns in
informatica?
- 5 Answers
- 22062 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / reni
Create one dummy record for each table:
from 2 source qualifiers connect a expression
transformation to create a output port as "Dummy" & assign
the value "1" to that port.
Then in joiner join based on this dummy port of two
different source.
| Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
Briefly explain the aggregator transformation?
What is standalone command task?
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
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
How to use pmcmd utility command?
what is the hint? how to use it to reduce the query processing in program?
How are indexes created after completing the load process?
can we override a native sql query within informatica? Where do we do it?
What is a passive transformation?
Which are the different editions of informatica powercenter that are available?
Explain about cumulative Sum or moving sum?
Implementation methodology
Define Pmrep command?
What is Data Caches size?
Difference between Target-based loading and constraint-based loading?
