HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND
LOOKUP?
Answer Posted / senthil
USE SOURCE QUALIFIER WHILE MAPPING CREATED ...
| Is This Answer Correct ? | 1 Yes | 20 No |
Post New Answer View All Answers
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
How to generate sequence numbers without using the sequence generator transformation?
How does a sorter cache works?
Why is sorter an active transformation?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What are the limitations of joiner transformation?
What are the different options available for update strategy?
How to do the error handling of if ur source is flatfiles?
What is primary and backup node?
What is dynamic cache?
What is the use of an aggregator cache file?
Explain incremental aggregation in informatica
What is a connected transformation?
Can informatica load heterogeneous targets from heterogeneous sources?
What are the main issues while working with flat files as source and as targets ?