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
Can we override a native sql query within informatica?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Explain joiner transformation in informatica
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Suppose we do not group by on any ports of the aggregator what will be the output?
What is confirmed fact in dataware housing?
What can we do to improve the performance of informatica aggregator transformation?
Explain incremental aggregation in informatica
What is the function of union transformation?
Explain what are the different versions of informatica?
Separate from an archive server and a powerhouse?
Briefly define a session task?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
How you prepared reports for OLAP?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?