How to join a Flat and Relational Source without using (Joiner,
Update and Lookup ) transformations... is it possible? if yes i
would like to know how?
Answer Posted / anoymous
Not possible to join flat file without transformations
however relational sources can be joined in source qualifier
ex: select * from emp,dept;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is the procedure for creating independent data marts from informatica 7.1?
What are the different types of transformation available in informatica.
Briefly define reusable transformation?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Could you explain what is enterprise data warehouse?
What is the difference between router and filter?
What are session parameters ? How do you set them?
can u any challenge your project?
What is the surrogate key?
What is source qualifier transformation in informatica?
Define filter transformation?
Explain the different lookup methods used in informatica?
I have a flat file, want to reverse the contents of the flat file
differences between service based and product based?