how to join the two flatfiles using the joiner t/r if there
is no matching port?
Answer Posted / sudhar
Connect the source Qualifier of two different flat files to
two different Exp Trans. Create a dummy output port in both
the exp trans. then using that port connect the joiner
Tansformation
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
How do you load unique records into one target table and duplicate records into a different target table?
Difference between Data and Index Caches?
Explain what are the different versions of informatica?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Explain the pipeline partition with real time example?
can we override a native sql query within informatica? How do we do it?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
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
Explain scd type 3 through mapping.
wat are deployement groups in informatica, how it will be used for developers
What are junk dimensions?
How does the aggregator transformation handle null values?
Explain incremental aggregation in informatica
What is Session and Batches?
Where is metadata stored?