DSXchange

Hi Mukejee,

http://help.sap.com/

https://www.sdn.sap.com/

Hope these two links help you.


thanks
fareeda

Hi ,

Which version of datastage (parallel job) is support the window platform (windows xp , professional) to install on local pc .

thanks in advance

fareeda

Hi,

you can use "decimalTo String function" in transformer stage .


Hope it will help you.


thanks
fareeda

Hi,

you can use "decimalTo String function" in transformer stage .


Hope it will help you.


thanks
fareeda

Hi ,

SELECT COUNT(1), COLUMN_NAME
FROM TABLE_NAME
GROUP BY COLUMN_NAME
HAVING COUNT(1) > 1


hope this might help you.


thanks
fareeda

Hi chulett ,

sure will do

thanks for your co-operation

Hi all,

how do write multiple output lines from a single input line?


thanks

Hi vinod ,

DataStage Test Topics
http://www-03.ibm.com/certify/tests/obj415.shtml


The Prometric Site - so you can register for the exam!
http://www.prometric.com/IBM/default.htm


thanks
fareeda

Hi Vijay,

in db2 we have to use substr function

Example:select substr(empid,2,len(empid)) from schemaname.tablename;

try this one

hope it will help you.

if iam wrong correct me

thanks
fareeda

Hi Prashanth ,
could you please explan me how this date issue got resolved ?

thanks
fareeda

Hi Prashanth ,
could you please explan me how this date issue got resolved ?

thanks
fareeda

Hi hemantha kumar,

need clarification on last calender date if i want 2008-12-31 date .

could you please explan me how it will resolve this.


thanks
fareeda

Hi Sateesh,

Could you please explan how your doing this Last calender date function logic ?

thanks
fareeda

Hi Sateesh,

Could you please explan how your doing this Last calender date function logic ?

thanks
fareeda

Hi Deepak, In sort stage will have key change column right but we don't have option as key change=1 in transformer so how will remove dupilcates in transformer . my logic is take 3 stagevaraibles st1 =st3 st2= if stg1=stg3 then duplictae else Not-duplicate st3= column name if i'm wrong this please c...