Interested to Buy Any Domain ? << Click Here >> for more details...
how to join the 2 different table with different columns in
informatica?
- 5 Answers
- 23514 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
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
Enlist the various types of transformations.
What is the procedure for creating independent data marts from informatica 7.1?
What are the tuning techniques you applied during your last project
What happens when a session fails and you click on recover?
What is the difference between STOP and ABORT options in Workflow Monitor?
What are the differences between joiner transformation and source qualifier transformation?
What are the different types of olap? Give an example?
What is native users?
What is rank transform?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What are the advantages of using informatica as an etl tool over teradata?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is a surrogate key?
What is the need of an ETL tool?
