how to join the 2 different table with different columns in
informatica?
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
explain one complex mapping with logic? sales project?
How to do unit testing in informatica?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
How does a rank transform differ from aggregator transform functions max and min?
What is the benefit of partitioning a session?
Which are the different editions of informatica powercenter that are available?
is it possible to index the data in cache of lkp transformation ?
What are active transformations.
Explain pushdown optimization and types in informatica
How do you set a varible in incremental aggregation
What are the tasks that can be performed using sq?
What is data transformation manager process?
How to extract sap data using informatica?
Enlist the advantages of informatica.