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

What is a transaction control transformation?

0 Answers   Informatica,


Explain pmcmd command usage in informatica

0 Answers   Informatica,


Mention some types of transformation?

0 Answers  


Two Default User groups created in the repository are ____ and ______

2 Answers  


Can anyone briefly describe abt audit table loading?

2 Answers   TCS,






,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?

3 Answers   Emphasis,


can we override a native sql query within informatica? Where do we do it?

0 Answers  


why union is active transformation?

4 Answers   IBM,


Whatis the difference between View and Materialized View ?

11 Answers   Satyam, Syntel,


suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how

4 Answers   CTS,


without matching columns in two tables. how can you join

5 Answers   BirlaSoft,


How to load the data from a flat file into the target where the source flat file name changes daily?

0 Answers   Informatica,


Categories