Page 1 of 1
scd2-implementation
Posted: Tue Aug 05, 2008 6:48 am
by 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
Re: scd2-implementation
Posted: Tue Aug 05, 2008 6:54 am
by 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.
laknar wrote:When we load the records first time into the dimension table.
And? Incomplete sentence.
Posted: Tue Aug 05, 2008 7:00 am
by laknar
Hi,
Design is
SOurce-------lookup------transformer-------transformerSplit----insert and update.
I have insert the rec version when we load first time.
Posted: Tue Aug 05, 2008 7:07 am
by 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
Posted: Tue Aug 05, 2008 7:47 am
by chulett
laknar wrote:Im not able to insert new records when we load first time.
Why not? What happens, what error(s) are generated?
Details.
Posted: Tue Aug 05, 2008 8:02 am
by 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.
Posted: Tue Aug 05, 2008 4:16 pm
by ray.wurlod
Why don't you ask the author of the article at etl-tools.info?