DSXchange

Thanks
I have try a lot using look up but still I am getting matched data only in Target Table so please tell me if any Condition is required in lookup stage to get unmatch data in Target Table ?

Please help me if possible because I have not used Look up stage before to get Unmatched data

Thanks

Continue to above Post:

Or can I use look up stage ?
Please help me how ?
what to set in constraints. I have try that BUT I am failed. I am using 7.5.2

Thanks

Hi,
I want to get Unmtched data to be load in Target Table. I am comparing source record with the Target Table.

How can I do this with Merge Stage ?

Thanks

Thanks you very much

I used It works fine

Thanks again.

Thanks

I want that in PX.


Thanks

I want to do this in Datastage.


Thanks

Hi,

Can anyone help me how to calculate currentdate()-1 ?

Thanks

Thanks a lot

Thanks for Response

I am using PX so can you please tell me what properties to set in Agrregator Stage ?

Thank

Hi,

How to read DISTINCT sring from flat file ?
Can any one help ? Please ?

Date Length 10

Thanks

Thanks Ray,
I did as you said, I am doing as under( I am not using '=')

DateToString(CurrentDate(),"%mm/%dd/%yyyy") = StageVar1
StringToDate(StageVar1,"%mm/%dd/%yyyy") = Current_dt

Current_dt is giving me 2007-01-30 !!! How this is coming. Please help me.

Thanks

Hi, I search and read many Threads in this forum but I could not resolve my problem, Please help me.... I am using Currentdate as one of my column in Transformer which is in %yyyy-%mm-%dd format BUT I reqired in %mm/%dd/%yyyy format : I am doing(in Transformaer) : DateToString(CurrentDate(),"%m...

Thanks

to set your enivronment variables

that means Do I need to export LIBPATH in .profile file ?

I found .profile in $DSHOME so do I need to type following Quote only and save ?

export PATH
LIBPATH=/baselwb/dsadmhome/Ascential/DataStage/DSEngine/lib
export LIBPATH

Hi, When I am Using dsjob in Unix command line it is giving me following Error: ( I am not able to use this. How can I resolve this ? ) 0509-036 cannot load program dsjob because of the following errors: 0509-150 Dependent module libvmdsapi.so could not be loaded. 0509-022 cannot load module libvmds...