Interested to Buy Any Domain ? << Click Here >> for more details...
TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING
COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER
TRANSFORMATION ?
- 6 Answers
- 19693 Views
- HP, TCS, I also Faced
- E-Mail Answers
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
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is the maplet?
Explain the different dimensions.
Which version configuration tool used in ur project?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is a passive transformation?
What are the advantages of informatica?
What is a router transformation?
how to create user defined function (udf) in informatica
Separate from an archive server and a powerhouse?
How would you join a node to the already existing domain?
How can we use mapping variables in informatica? Where do we use them?
How big was your fact table
How to elaborate tracing level?
What is informatica? Why do we need it?
