Hi Guys, For the above req. we can't use SCD 1 or 2 or 3. Bcoz for

On a day, I load 10 rows in my target and on next day if I
get 10 more rows to be added to my target out of which 5 are
updated rows how can I send them to target? How can I insert
and update the record?

Question Posted / james

6 Answers
13212 Views
I also Faced
E-Mail Answers

Answer Posted / james

Hi Guys,

For the above req. we can't use SCD 1 or 2 or 3.
Bcoz for scd1 it inserts the new record and updates the
updated record.And here we wont be having any updated
records only new records will be there.

So according to me,the best option for the above scenario
is go with Incremental aggregation.

Please let me know if you have suggestions regarding this.

Thanks,
James.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why do you use Mapping Parameter and mapping variable?

1766

Define the various join types of joiner transformation?

988

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1866

How would you copy the content of one repository to another repository?

1019

what are factless facts? And in which scenario will you use such kinds of fact tables.

1810

Explain pushdown optimization $pushdownconfig parameter - informatica

1147

How many input parameters can exist in an unconnected lookup?

1546

What is primary and backup node?

1128

Mention some types of transformation?

1048

update strategy transformation in informatica

1065

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1130

What is a connected transformation?

1119

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1108

How can informatica be used for an organization?

1220

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1902