DSXchange

HI, thanks for your va;uable suggestions. but we are not supposed to export the code into another environment to compare

How to compare the code between two protected projects? My requirement is to compile the compare the data stage jobs between two projects, am working on 8.1 we have an options to compare jobs across the projeat but both the projects in protected so its open in read only that compare option is disabl...

Thanks for responding ray, but table name is same when i insert records manullay using insert statement its working fine

Hi ,, when am trying to load the data into teradata DB, through the teradata connector stage i got a below fatal error; ins_FCT_RETS_EXCEPTION_RECEIVING,0: RDBMS code 3737: Name requires more than 30 bytes in LATIN internal form. SQL statement: INSERT INTO YY_VIEWSD.FCT_RETS_EXCEPTION_RECEIVING(SEQ_...

Hi , how to do integer to decimal conversion , since i got a below warning in log When binding input interface field "FIN_VEND_I" to field "FIN_VEND_I": Implicit conversion from source type "int64" to result type "decimal[10,0]": Possible range limitation.

Hi ...

I have an requirement like to send a notification mail if the count of records in two tables not same, those two tables populated in same job.

Any suggestions how to handle this

Hi .. i got a location its in /opt/Ascential/DataStage/PXEngine/bin path i have some commands to work on datasets , but i need a small clarification on copying datasets. $orchadmin copy <source.ds> <destination.ds> , i have a dataset named as chk.ds , in <source.ds> do i need to give chk.ds or entir...

Where can i see the Orchadmin command in my unix box, i tried to search the below path /opt/Ascential/DataStage/DSEngine/bin , But its not available.

Can any one suggest me ???

Use Null handling functions , Specify any default value if its nulll

THanks... for reply, other than this any alternative method, since i tried this method but i had to handle leap years additionally.

It saying something like Job3 just reset only , you can check job3 log you may get any additional info ..

Hi all.

I have a small issue with julian day , usually am aware of how to calculate the julian day from date .

its give Jan1 - 1
jan2 - 2
But in my requirement Fiscal year starts from Jul1 so it should give

Jul1 -1
Jul2 - 2

Any suggestions ????

No , Am not facing any problem but requirement saying Don't use if then else and lookup file or data stage routine ...

Thanks for responding ....

Is there any data stage built in function to handle this ???

HI ,

I have a funny requirement like , i have a source filed it contains distinct integer values 1 to 12 , my requirement is if its
1 - janauary
2 - febrauary
3 - march ....

Is there any way other than writing a Stage variables .