Answer Posted / rekha
SCD IS SLOWLY CHANGING DIMENSION
SLOWLY CHANGING DIMENSIONS ARE DIMNESION TABLES WITH SLOWLY
INCREASING DATA AS WELL AS UPDATES TO THE EXISTING DATA
THERE ARE THREE TYPES OF DIMENSIONS
TYPE 1
TYP2 - VERION ,FLAG ,EFFECTIVE
TYPE3
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
How can we use mapping variables in informatica?
Can u generate reports in Informatica?
Define update strategy?
Explain the code page compatibility?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is a shortcut and copy in Informatica and how two are different with each other?
What is flashback table ? Advance thanks
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How do you set a varible in incremental aggregation
What is data transformation manager process?
Why do you use Mapping Parameter and mapping variable?
Name the different lookup cache(s)?
How we can use union transformation?
Explain why we use partitioning the session in informatica?
