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 / mike

1)Yes..you can use a lookup transformation on flatfiles.

2)I think we can use most of the transformations on
flatfiles.
But we can not apply slowly changing dimensions on flat
files.

correct me if i was wrong

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

where to store informatica rejected data? How to extract the informatica rejected data?

688


What is fact table? Explain the different kinds of facts.

691


Where do we use mapping variables in informatica?

705


What is the advantage of informatica?

738


update strategy transformation in informatica

745






Explain the code page compatibility?

731


Differences between version 7.x and 8.x.

1521


How to configure mapping in informatica?

773


What is Data Caches size?

736


Define Pmrep command?

723


What do you understand by SOA of Informatica?

668


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1776


Explain the use of aggregator cache file?

798


Which are the different editions of informatica powercenter that are available?

666


What is a joiner transformation and why it is an active one?

653