Interested to Buy Any Domain ? << Click Here >> for more details...
how to join the 2 different table with different columns in
informatica?
- 5 Answers
- 23731 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
Informatica Checkpoints
What is a standalone command task?
What is the use of source qualifier?
What is meant by lookup transformation? Explain the types of lookup transformation?
How to update a particular record in target with out running whole workflow?
What are the uses of etl tools?
What is an expression transformation?
What are the tuning techniques you applied during your last project
Explain sessions?
What is the Rank index port in Rank transformation?
Sequence generator, when you move from develoment to production how will you reset
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What are the mapping parameters and mapping variables?
Define mapping and session?
Do you find any difficulty while working with flat files as source and target?
