while creating the scd mappings. we will mention flag value.
what exactly the use of defining the FLAG VALUE. Please
explaine indetaile

Answer Posted / rohan

in SCD2, the flag value indicates whether the record is the active record(Current version of the record) or not.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

8556


Differences between connected and unconnected lookup?

610


What are the different components of powercenter?

582


What are the advantages of using informatica as an etl tool over teradata?

567


Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

553






can u any challenge your project?

1608


What is the difference between a repository server and a powerhouse?

809


What is rank transformation in informatica

691


What all join we can perform in LOOKUP transformation?

567


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

1838


What are the types of data warehouses?

944


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1517


Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

633


How would you copy the content of one repository to another repository?

557


What is native users?

725