can you use flat file for lookup table?why?
Answers were Sorted based on User's Feedback
Answer / gyana
yes we can....we can definitly use the flat file as
lookup .....but we can not use the xml files as look
up...if u want to use then u have to change the xml file to
another database or flatfile..dn u can able to use
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / gyana
yes we can....we can definitly use the flat file as
lookup .....but we can not use the xml files as look
up...if u want to use then u have to change the xml file to
another database or flatfile..dn u can able to use
Is This Answer Correct ? | 2 Yes | 0 No |
what are the limitation of sorter transformation?
What is a snowflake schema?
Mention few power centre client applications with their basic purpose?
performance tuning of Informatica
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is the difference between view and materialised view?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Explain what are the different versions of informatica?
What is workflow manager?
What is the role of informatica in project ?Like i showed financial projects?
Briefly describe lookup transformation?
how do u fnd the duplicate rows and how to delete the duplicate rows?