merge stage problem

dsx_venkat · Post by **dsx_venkat** » Mon Oct 10, 2005 5:08 am

Hi All,

I am using merge stage.

Master link record
------------------
1 a
2 b
3 c

Update link record
------------------
1 0001-01-01 00.00.00
2 0001-01-01 00.00.00

Output record
1 a 0001-01-01 00.00.00
2 b 0001-01-01 00.00.00
3 c *******************

I am getting ******************* for the master record which dont have match in the update link record. But i am suppose to get the default value that i have given in the output field properties. Anybody knows why i am getting this.

Regards.
venkat

kumar_s · Post by **kumar_s** » Mon Oct 10, 2005 5:49 am

Hi,
Default/Nullable feild value should work.
Try altering dsx and specifying default in merge stage itself.

regards
kumar

dsx_venkat · Post by **dsx_venkat** » Mon Oct 10, 2005 6:12 am

No, even Default/ Nullable is not working.

No need to edit the dsx, bcas after the merge stage i am having an output stage, so i can change the field properties here itself.

The output field is ********* in the output text file, but when i tried to view the file in the datastage, it is assigning the default value.

roy · Post by **roy** » Mon Oct 10, 2005 7:40 am

Hi,
Regarding your private message Please Read Ray Wurlod's article in the latest news-letter.
By the way If I had time I would have looked at it.
I only logged in since I get email notifications on new private messages here, not because I had some spare time right now sorry.
Thanks,

Nripendra Chand · Post by **Nripendra Chand** » Tue Oct 11, 2005 4:58 am

It seems that data type of output field is datetime and you are not putting default value in proper format. Put the default value in output datatype format. It should work.

-Nripendra