What are slowly changing dimensions?
Answer Posted / anitha
scds are three types.
type1:it stores the current data.
type2:it stores the full historical data.
type3:it stores the current and previous data in the target...
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
What is the format of informatica objects in a repository?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is the use of target designer?
What are the advantages of informatica?
How can we create index after completion of load process?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Why update strategy and union transformations are active? Explain with examples.
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What is the Process to creating lookup transformation in informatica
if we have a delimiters at unwanted places in a flat file how can we over come those.
Enlist the advantages of informatica.
Slowly changing dimensions, types and where will you use them
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Explain the use of aggregator cache file?
Explain Dataware house architecture .how data flow from intial to end?