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
What is depict expression change?
What is the difference between stop and abort in informatica
How many ways a relational source definition can be updated and what are they?
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
if we have a delimiters at unwanted places in a flat file how can we over come those.
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is native users?
Sequence generator, when you move from develoment to production how will you reset
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is workflow monitor?
What are the measure objects?
What is substr in informatica?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is dimensional table?
What is main use of mapplet?