Interested to Buy Any Domain ? << Click Here >> for more details...
HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND
LOOKUP?
- 11 Answers
- 31868 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / avru.bal
we can join the 2 flat files by using filerepsitory..save
both files in one directory gve the path name c:\.txt and
provide default type=oracle then apply,
in session properties provide
source file directory:c:/txt
source file type:indirect
provide target connection..so that we can join the both
files without using joiner n lookup
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
How many numbers of sessions can one group in batches?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is informatica? Why do we need it?
What is pmcmd command?
What is the difference between stop and abort in informatica
What is standalone command task?
Suppose we do not group by on any ports of the aggregator what will be the output?
Differentiate between a repository server and a powerhouse?
What are the issues you have faced in your project? How did you overcome those issues?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
what is the hint? how to use it to reduce the query processing in program?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How can we improve session performance in aggregator transformation?
How do you update the records with or without using update strategy?
What are the components of Informatica? And what is the purpose of each?
