Interested to Buy Any Domain ? << Click Here >> for more details...
HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND
LOOKUP?
- 11 Answers
- 32273 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
What is substr in informatica?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
What do think which one is the better joiner or look up?
can anyone explain me about retail domain project in informatica?
Explain why we use partitioning the session in informatica?
In which transformation you cannot drag ports into it?
What are the different components of powercenter?
Can informatica load heterogeneous targets from heterogeneous sources?
How do you load first and last records into target table?
During the running session, output files are created by informatica server. Enlist few of them.
Which are the different editions of informatica powercenter that are available?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
scenario where i can use only concurrent execution of workflow.
can u give example for factless fact table
