By using the scd2..we can keep the track of the old and new records. Ther

how to identify new and old values in source qualifier or
any other transformations using informatica

Question Posted / sanjay

Answer Posted / sanjay

By using the scd2..we can keep the track of the old and new
records.
There are 3 ways:
1.Version Num
2.Date
3.Flag

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain the different lookup methods used in informatica?

972

Can you generate sequence numbers without using the sequence generator transformation?

1046

explan ur project architecture?

2004

Can we create a node as a gateway node and the same node can be assigned to a grid?

1025

write a query to retrieve the latest records from the table sorted by version(scd)

999

Define mapplet?

961

what are the Methods For Creating Reusable Transformations?

1098

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6038

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7311

Explain what are the different types of transformation available in informatica.

1037

What is the benefit of session partitioning?

1039

What is Cognos script editor?

4158

Scheduling properties,whats the default (sequential)

1888

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1931

What are the different clients of powercenter?

1006