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
where to store informatica rejected data? How to extract the informatica rejected data?
What is fact table? Explain the different kinds of facts.
Where do we use mapping variables in informatica?
What is the advantage of informatica?
update strategy transformation in informatica
Explain the code page compatibility?
Differences between version 7.x and 8.x.
How to configure mapping in informatica?
What is Data Caches size?
Define Pmrep command?
What do you understand by SOA of Informatica?
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
Explain the use of aggregator cache file?
Which are the different editions of informatica powercenter that are available?
What is a joiner transformation and why it is an active one?