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
scd2-implementation
Moderators: chulett, rschirm, roy
Re: scd2-implementation
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.
And? Incomplete sentence.laknar wrote:When we load the records first time into the dimension table.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: