can you use flat file for lookup table?why?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Define sessions in informatica etl?

609


have u done any performance tuning? how u ll do?

1849


Name at least 5 different types of transformations used in mapping design and state the use of each.?

660


How do you set a varible in incremental aggregation

1432


Under what conditions selecting sorted input in aggregator will still not boost session performance?

622






How to load a Dimension ? and how to load a fact table?

943


Explain constraint based loading in informatica

648


Difference between Data and Index Caches?

643


What is the use of source qualifier?

659


Explain the features of connected and unconnected lookup.

529


What is joiner transformation?

574


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1467


Differentiate between source qualifier and filter transformation?

987


Briefly explain the aggregator transformation?

582


Can anyone tell me the new features in Informatica 9 Version?

1521