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

Differentiate between reusable transformation and mapplet.

0 Answers

Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,

7 Answers Tech Mahindra,

What is mapping debugger?

0 Answers

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

1 Answers

If I am having 6 flat files in data. How can you load the data at a time

2 Answers CSC,

We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??

2 Answers

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

0 Answers

What is the format of informatica objects in a repository?

0 Answers

what are the transformations that are used in data cleansing ? and how data cleansing takes place ?

3 Answers

I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution

5 Answers

what is unit testing?tell me proceedure

0 Answers L&T, UST,

How to compare Source and Target table, without using dynamic lookup?

4 Answers

For more Informatica Interview Questions Click Here