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

Answers were Sorted based on User's Feedback



while creating the scd mappings. we will mention flag value. what exactly the use of defining the ..

Answer / 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

while creating the scd mappings. we will mention flag value. what exactly the use of defining the ..

Answer / kishor baindoor

In SCD each record is flaged in mapping logic so that
record will either inserted or upated or deleted
accordingly. You can flag record as 'I' or 'U' or 'D'

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More Informatica Interview Questions

Write the advantages of partitioning a session?

0 Answers  


What are mapplets? How is it different from a Reusable Transformation?

0 Answers   Informatica,


How do you change parameter when you move it from development to production.

1 Answers  


How do you manage the Parameter files while migrating your data from one environment to another environment?

0 Answers  


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

0 Answers   Informatica,






COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

0 Answers  


we r using aggregator with out using groupby?

7 Answers   HSBC, Principal Finance,


What is the default source option for update stratgey transformation?

1 Answers  


How can you validate all mappings in the repository simultaneously?

0 Answers  


What are the transformations that are not supported in mapplet?

0 Answers  


What are the join types in joiner transformation?

1 Answers   Informatica,


What is a snowflake schema?

0 Answers  


Categories