HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND
LOOKUP?
Answer Posted / tulasi pavani.k
If two flat files are of same structure we can join by
creating one list file and by writing the the names of those
two flat files in one text file.
source file directory:c:/order.txt
source file type:indirect
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What is dimensional table? Explain the different dimensions.
What are the different types of olap? Give an example?
What is sq transformation?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What are the differences between oltp and olap?
How to create a non-reusable instance of reusable transformations?
Which is the t/r that builts only single cache memory?
What are connected or unconnected transformations?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Repository user profiles
What is a joiner transformation and why it is an active one?
What the difference is between a database, a data warehouse and a data mart?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is the fact table?