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
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What could be the possible resons of locks by user?
What is intricate mapping?
Explain lookup transformation source types in informatica
How can we use mapping variables in informatica? Where do we use them?
difference between informatica 8.1.1 and 8.6
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How might you approve all mappings in the archive all the while?
can u give example for factless fact table
What all are steps in up gradation of Informatica server?
Differentiate between router and filter transformation?
define galaxy repository in informatica
What are data-driven sessions?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Different sorts of metadata that stores in the storage facility?