can you use flat file for lookup table?why?

Answers were Sorted based on User's Feedback



can you use flat file for lookup table?why?..

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

can you use flat file for lookup table?why?..

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

Post New Answer

More Informatica Interview Questions

what are the limitation of sorter transformation?

2 Answers   TCS,


What is a snowflake schema?

0 Answers  


Mention few power centre client applications with their basic purpose?

0 Answers  


performance tuning of Informatica

1 Answers  


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)

0 Answers   Saama Tech,






What is the difference between view and materialised view?

6 Answers  


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

0 Answers  


Explain what are the different versions of informatica?

0 Answers  


What is workflow manager?

0 Answers  


What is the role of informatica in project ?Like i showed financial projects?

1 Answers   Amdocs,


Briefly describe lookup transformation?

0 Answers  


how do u fnd the duplicate rows and how to delete the duplicate rows?

2 Answers   IBM,


Categories