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
6703 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

we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.

2 Answers Infosys, TCS,

Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.

0 Answers

Can anyone briefly describe abt audit table loading?

2 Answers TCS,

what are the different types of transformation available in informatica and what are the mostly used ?

3 Answers TCS,

Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?

4 Answers

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

0 Answers

What is CDC? How to implement CDC?

4 Answers People Tech, TCS,

which one is better performance wise joiner or look up

0 Answers Informatica,

Can we update a target table (without primarykey) by using update strategy transformation?

4 Answers TCS,

How to add source flat file header into target file?

3 Answers Logica CMG,

how much memory (size) occupied by a session at runtime

4 Answers Wipro,

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

0 Answers IBM,

For more Informatica Interview Questions Click Here