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


Please Help Members By Posting Answers For Below Questions

How to elaborate tracing level?

683


Explain the use of aggregator cache file?

677


Difference between Target-based loading and constraint-based loading?

551


write a query to retrieve the latest records from the table sorted by version(scd)

631


What is option by which we can run all the sessions in a batch simultaneously?

665






What is joiner transformation?

585


Write the prerequisite tasks to achieve the session partition?

641


What is event and what are the tasks related to it?

613


What is the benefit of partitioning a session?

624


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

614


What are some examples of informatica etl programs?

533


Where is metadata stored?

622


How are indexes created after completing the load process?

987


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1629


What is data transformation manager process?

619