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
- 19516 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
How to load a Dimension ? and how to load a fact table?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
How are the sources and targets definitions imported in informatica designer?
What is a node in Informatica?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
what is index?how it can work in informatica
What are pre and post-session shell commands?
How do you take back up of repository?
What is Session and Batches?
How to do unit testing in informatica?
Whats there in global repository
