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
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?
Differences between connected and unconnected lookup?
What are the different components of powercenter?
What are the advantages of using informatica as an etl tool over teradata?
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?
can u any challenge your project?
What is the difference between a repository server and a powerhouse?
What is rank transformation in informatica
What all join we can perform in LOOKUP transformation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What are the types of data warehouses?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
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?
How would you copy the content of one repository to another repository?
What is native users?