How to join a Flat and Relational Source without using (Joiner,
Update and Lookup ) transformations... is it possible? if yes i
would like to know how?
- 10 Answers
- 23378 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / mallikarjun
Hi Ajith,
It is Possible to Join data from a flat file and a relation
source, this can be done with the help of a joiner
transformation where you have to map one input port to the
relation data column and other to the flat file coumn and
give the joiner condition.. Hope this will help you or drop
a mail...
Thanks & Regards,
Mallikarjun
| Is This Answer Correct ? | 3 Yes | 10 No |
Post New Answer View All Answers
have u done any performance tuning? how u ll do?
Differentiate between joiner and lookup transformation?
How can informatica be used for an organization?
What can we do to improve the performance of informatica aggregator transformation?
Explain sessions. Explain how batches are used to combine executions?
How does a rank transform differ from aggregator transform functions max and min?
Explain transaction control transformation in informatica
Design a mapping to load the cumulative sum of salaries of employees into target table?
Describe the impact of several join conditions and join order in a joiner transformation?
What are the data movement modes in informatica?
Different sorts of metadata that stores in the storage facility?
Write the unconnected lookup syntax and how to return more than one column.
What is deployment group?
What is rank transform?
What is the different lookup cache(s)?
