I think this is the concept of scd type 3

Hi,
In source I have records like this
No name address
10 manoj mum
10 manoj dilhi
20 kumar usa
20 kumar Tokyo
I want records in target like shown below
No name addr1 addr2
10 manoj mum dilhi
20 kumar usa Tokyo

If it is reverse we can do this by using Normalizer
transformation by setting occurance as 2.
Somebody will say use denoralization technique. But as of my
knowledge I couldn’t find any denormalization technique. Is
there any concept like that?
I tryid this seriously but I could find any idea to
implement this.
Can any one please help me ?
Advance Thanks

Question Posted / honey

6 Answers
8303 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / honey

I think this is the concept of scd type 3

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Which transformation should we use to normalise the COBOL and relational sources?

1272

 Informatica Checkpoints

3378

draw informatica architecture 8.6 ?

3931

Explain joiner transformation in informatica

1174

which one is better performance wise joiner or look up

1151

What is meant by incremental aggregation?

1185

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3927

What is lookup transformation?

1094

What is decode in static cache?

1263

Explain the use of aggregator cache file?

1318

Why update strategy and union transformations are active? Explain with examples.

1285

Briefly describe lookup transformation?

1097

Differentiate between Load Manager and DTM?

2215

What is deployment group?

1300

How might you approve all mappings in the archive all the while?

1085