Hi,
I am facing problem with SCD stage while compliing the job it is giving the following error
"If at least one type 2 column present,then SCd stage requireds either a current indicator column or expire date column(or both) to be present inthe dimension table.
but in my SCD stage both having...
Any ideas....
Regards,
venki
SCD stage compilation error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 247
- Joined: Mon Jan 22, 2007 11:33 pm
stage not available
Hi ,
I have not come accross the stage in my Datastage Enterprise Edition 7.2. I have searched the manuals too .but i dont find any clue on where the stage is![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
I have not come accross the stage in my Datastage Enterprise Edition 7.2. I have searched the manuals too .but i dont find any clue on where the stage is
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
Regards
Ragu
Ragu
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Post (fully) what's on each of the four tabs in your SCD stage. Without that it's difficult to diagnose. Verify your assertion that you have both a current indicator column and an expiry date column.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 106
- Joined: Wed Oct 04, 2006 5:21 am