Error while parameterize the surrogate file in SCD stage
Moderators: chulett, rschirm, roy
Error while parameterize the surrogate file in SCD stage
When I give the full path of surrogate flat file in SCD stage to generate the Surrogate key, it works fine. But when I parameterize the surrogate flat file , SCD stage gives compile error. Please let me the reason.
ex..var/spool/hs/land/surr_file.txt----It works fine.
$DS_LAND$/surr_file.txt---It gives compilation error.
ex..var/spool/hs/land/surr_file.txt----It works fine.
$DS_LAND$/surr_file.txt---It gives compilation error.
Nirdesh Kumar
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
nirdesh2 wrote:I am not hard coding. I am giving the parameter using Parameter GUI and its like #$DS_LAND#/surr_file.txt
If its really
Code: Select all
#$DS_LAND#/surr_file.txt
And tell us the result.
Regards,
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.![Wink :wink:](./images/smilies/icon_wink.gif)
Genius may have its limitations, but stupidity is not thus handicapped.
![Wink :wink:](./images/smilies/icon_wink.gif)
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi,
We used to face the same issues with Teradata multiload stage in DS 7.5. We could not use the $. What we did was to create local job parameter say DS_LAND. Then we use the actual environment variable say $DS_LAND in the Job Sequence as a parameter. We map the $DS_LAND to DS_LAND in the job activity. This is a work around.
HTH
--Rich
We used to face the same issues with Teradata multiload stage in DS 7.5. We could not use the $. What we did was to create local job parameter say DS_LAND. Then we use the actual environment variable say $DS_LAND in the Job Sequence as a parameter. We map the $DS_LAND to DS_LAND in the job activity. This is a work around.
HTH
--Rich
IF I remember correctly, I think we did get a patch from support for this issue. It didn't work... and I wasn't in the mood to pursue it further. I just did a workaround by using a regular job parameter.
I was using AIX 5.3 server, Windows XP client, and version 8.0.1. Maybe the patch works on other releases... maybe the patch has been patched... I ran into this last fall.
Mike
I was using AIX 5.3 server, Windows XP client, and version 8.0.1. Maybe the patch works on other releases... maybe the patch has been patched... I ran into this last fall.
Mike