in which situations do u go for scds ?

Answer Posted / rajan raorane

SCDs are basically used to updates in existing data or to
maintain history Data along with existing one

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to do the error handling of if ur source is flatfiles?

1507


What does role playing dimension mean?

621


How many ways are there to create ports?

725


What do you understand by a term domain?

666


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

7669






How to create or import flat file definition in to the warehouse designer?

609


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??

555


Why update strategy and union transformations are active? Explain with examples.

705


How to join three sources using joiner? Explain though mapping flow.

693


design of staging area?

1585


Define mapping and session?

582


update strategy transformation in informatica

638


What is parallel processing in informatica?

1024


Target increases every day even though no new record was inserted

1103


In which transformation you cannot drag ports into it?

776