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

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

2 Answers
6835 Views
Amdocs, I also Faced
E-Mail Answers

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

surrogate keys usage in Oracle and Informatica?

5 Answers ITC Infotech, Oracle,

Can we create multiple integration service on single repository?

0 Answers

how to insert header after each group.

1 Answers IBM,

In a table, 4 person having same salary. How to get Third person record only?

15 Answers

Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static

2 Answers Accenture,

The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?

3 Answers Cap Gemini,

my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.

5 Answers IBM,

What is a standalone command task?

0 Answers

According to his methodology what all you need before you build a datawarehouse

0 Answers

what r the values tht r passed between informatics server and stored procedure?

1 Answers

what is update strategy transformation ?

7 Answers TCS,

Describe the impact of several join conditions and join order in a joiner transformation?

0 Answers

For more Informatica Interview Questions Click Here