HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND
LOOKUP?
- 11 Answers
- 28684 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / rahul patil
All the above approaches are not correct because question was to join two flat files... if we use indirect file or unix command or joiner trns, we could only union two files but not join.
If we have file1 --- 100 records and
file2 --- 100 records then through above approaches we would have only 200 records.
But a join without join condition would return cartesian product and in our case count should be 10000.
Rahul Patil
DWHKID
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
server hot-ws270 is connect to Repository B. What does it mean?
Enlist the various types of transformations.
How do you load first and last records into target table?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How can repository reports be accessed without sql or other transformations?
What is meant by lookup transformation? Explain the types of lookup transformation?
Why do we need informatica?
Please let me know how to make encryption and decryption with example?
design of staging area?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What are mapplets? How is it different from a Reusable Transformation?
Explain load alternative records / rows into multiple targets - informatica
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Partition, what happens if the specified key range is shorter and longer
