can we use lookup t/r in flat files?what are the t/r's can be
used in flat files when compared to relational DB?

Answer Posted / rajan raorane

No we can apply slowly changin dimensions on flat files
as they are basically used to mantian history

frequently used is SDC2 (Verison/flag/Date)

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to load the data from a flat file into the target where the source flat file name changes daily?

661


How many numbers of sessions can one group in batches?

697


How can you generate reports in informatica?

668


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1674


What is the difference between source qualifier transformations source filter to filter transformation?

708






What happens when a session fails and you click on recover?

743


What is an aggregator transformation?

721


Where do we use mapping variables in informatica?

705


How to create Target definition for flat files?

867


tell me about your project functionality

1970


can you please explain me pre session and post session options?

6623


What is the use of code page?

691


What is sequence generator transformation in informatica?

714


What are active and passive transformations?

724


What is informatica powercenter repository?

813