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
Enlist few areas or real-time situations where informatica is required.
Explain in detail about scd type 1 through mapping.
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is the difference between informatics 7x and 8x and what is latest version?
what is the size of your data warehousing?
What is the cumulative sum and moving sum?
What is domain in terms of informatica?
How can we store previous session logs?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is the way to execute pl/sql script using informatica mapping?
What is a stored procedure transformation?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What are mapplets? How is it different from a Reusable Transformation?
what is the hint? how to use it to reduce the query processing in program?