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

How an expression transformation differs from aggregator transformation?

630


What are the advantages of using informatica as an etl tool over teradata?

569


can any one give some examples for pre sql and post sql(Except dropping and creating index).

3518


One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

1753


Design time, run time. If you don't create parameter what will happen

1428






What is the difference between router and filter?

651


Name the different lookup cache(s)?

713


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1635


What is dimensional table?

625


The question was on time stamp. what is the difference between HH and HH24 when to use when.

1563


Is there any way to read the ms excel datas directly into informatica?

552


What is a router transformation?

634


How to use procedural logic inside infromatica?

640


How might you approve all mappings in the archive all the while?

603


can anyone explain me about retail domain project in informatica?

7442