scd2-implementation

[laknar]

Hi,

I have exactly the same design.

When we load the records first time into the dimension table.
How can i load without Suurogate key stage,trigger.

Please advice me

exactly the same design in ETL Tools Info.

etl-tools.info - datastage-tutorial- scd2-implementation

[chulett]

Details, please. Explain the details of your job design and what exactly you are trying to find out by posting here. Is your job working but you are looking for alternate designs for some reason? Be precise.

When we load the records first time into the dimension table.

And? Incomplete sentence.

[laknar]

Hi,

Design is

SOurce-------lookup------transformer-------transformerSplit----insert and update.

I have insert the rec version when we load first time.

[laknar]

http://etl-tools.info/en/datastage-tuto ... astage.htm


Im not able to insert new records when we load first time.
How to insert the record version for first time load

For next time i can upto into REC_VERSION+1

[chulett]

Im not able to insert new records when we load first time.

Why not? What happens, what error(s) are generated? Details.

[laknar]

the thing i have used existing as reference and New as source.
In reference i dont have any records.
so we populating the records first time.
how do i insert the records with rec version.

[ray.wurlod]

Why don't you ask the author of the article at etl-tools.info?