Duplicate record insert with other value

[devanars]

I have a requirement like
If id=1 and cd=10 then 'a'
If id=1 and cd=10 then 'b'
If id=1 and cd=10 then 'c'
if the same record comes again from source then need to chage the value
target is oracle table.

May i know the logic behind this to do

[ray.wurlod]

Sort, generate key change column in Sort stage, use this to flag in Transformer stage when you need to "increment" the value.

[devanars]

This requirement is not to increment.output is a string value. is there any idea of disign.

[Sainath.Srinivasan]

Use a column generator with list of values.

[chulett]

Note that Ray did not say increment, he said "increment". There's a reason why it was in quotes.

[devanars]

All records are coming from source no need to generate a column in the middle. the way source records are coming need to insert in target
All three recors are coming from the source with the same value

First record will insert directly with one value
Second record will be duplicate so it is not going to insert directly then need to inset with other value for same target fields.



Please let me know if i am not able to explain properly

[swades]

... then need to inset with other value for same target fields.

What do you mean by "other value" you can insert "ANY" value or is there specific requirement to insert?

[devanars]

Yes Specific requirement values are there. sorry for not able to give proper details.

[RAJARP]

hi,
if it is possible to use an oracle enterprise stage,you can give rank() function or row _number() a try.

Regards,
Raja R P

[ray.wurlod]

You can "increment" a single character.

Code: Select all

Char(Seq(prevcharacter)+1)