TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING
COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER
TRANSFORMATION ?
Answer Posted / mubbasir
This can be done by passing all ports to an expression
transformation and then creating a output port say ID=1 in
both the expression transformation of each file and then
join it using a joiner on ID,hope this helps..
| Is This Answer Correct ? | 9 Yes | 4 No |
Post New Answer View All Answers
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is sequence generator transformation in informatica?
What is meant by a domain?
How you know when to use a static cache and dynamic cache in lookup transformation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Where are the source flat files kept before running the session?
where to store informatica rejected data?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Enlist the advantages of informatica.
What do you mean by worklet?
What are the new features of informatica 9.x in developer level?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
How to implement security measures using repository manager?
What is a joiner transformation?
Which development components of informatica have the highest usage?