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
Explain what are the different types of transformation available in informatica.
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Is it possible to create multiple domains on a single Informatica server?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
As union transformation gives UNION ALL output, how you will get the UNION output?
What is sq transformation?
How do you load only null records into target?
What are the types of schemas we have in data warehouse and what are the difference between them?
What are data-driven sessions?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Where do we use mapping variables in informatica?
Differentiate between a database and data warehouse?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Clarify the utilization of aggregator cache record?