1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / ravikumar2614

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

How do you update the records with or without using update strategy?

0 Answers  

Which transformation is needed while using the Cobol sources as source definitions?

0 Answers   Informatica,

my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica

3 Answers   HP,

What is an incremental loading? in which situations we will use incremental loading

2 Answers   HCL,

we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?

1 Answers   Polaris,




What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1

4 Answers   IBM,

wf dont have integration severances how you can run?

0 Answers   TCS,

Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?

2 Answers   TCS,

What is difference between stored procedure transformation and external procedure transformation?

2 Answers  

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?

7 Answers   Target,

What is flashback table ? Advance thanks

0 Answers   Puma,

What is the Router transformation?

2 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories