DSXchange

hi,
i am truncated a staging table by using (truncate table aa )in before user defined sql , I was thinking to write this same function in datstage server
and call it from there in sequence , plz advice .
Thanks
Bobby

hi,
we are using datastage server , plans are to upgrade to parallel extender
plz advice how much easy it is to switch as i have not worked on extender
will it be easy to switch.
Thanks
Bobby

Hi frnds,
plz advice my date is in format 01-Aug-04(varchar) want to convert it to
08/01/2004(Date) .
Regards,
Bobby

Hi
TRUNC(F.CYCLE_DT, 'MONTH'),
gives like 01/02/04 in TOAD

In datastage Timestamp doesnot help ,i have to do varchar and it gives
me date like 01-feb-04 (Timestamp gives error attempt to convert string value unsuceesful, but time is in 01/02/04 in source)
plz Advice,
Regards
Bobby

The quickest approach is to turn the SELECT clause of the insert statement into a database view. Then you can import the metadata definition of the view straight into DataStage and retrieve rows from it I TRY this in TOAD and datasatge select statement DECODE(F.REVENUE_TYPE_KEY, 10000003, TRUNC(F.BI...

hI, I imported table in plugin metadata just add all columns to my rows and try to view the Data , Its taking forever, plz let me know wht i am thinking now is make 2 hash files of dim_subscriber and dim_subscriber_basic and and then matcing that hash files with fct_all_revenue could u pls guide, wh...

Hi there, They have no requirmnet all they gave SQL and want it be done in datastage, i have few question 1)As u said user defined SQL i think that will be quick fix , so u mean inport everything in plugin metadata and run user define query, 2) Making 2 hash files but i think i have to evaulate more...

Hi, Client gave a requirment like this they wanna it do with ETL now i have few quesions if u can help as they are using these 3 source table FROM clause , my question is how can i proceed in ETL job to get this query . Thanks Bobby INSERT INTO dwadmin.FCT_REVENUE_SUMMARY_JAN_2004 (SELECT MAX(F.REVE...

Hi
i am getting this error

$ SETFILE datastage01/NIN/NIN_hash updatecdatecoded OVERWRITING
ksh: SETFILE: not found
plz advice
Thanks
Bobby

hi
server is in unix

hi,
i have 2 columns in my hash file aa1 aa2, i want count of rows on cloumn aa1 in hash file
on column aa1,
i tried wc -w hashfile
it dont gave me count,
plz advice.
Thanks
Bobby

Hi frnds,
i just need some important information ADN told that server should be reinstall they send me some documents ,i was searching forum for some documention i cant find any help will be great .
Thanks
Bobby

hi,
i have waited more then 20 min still waiting did it takes too long.(any other option to find pid)
thanks
bobby

I WAS TRYING TO CLEAR JOB
BY DS.TOOLS --5 ---THEN 11 THEN JOBNAME NOW WHEN I SAY YES
IT HANGS BIT WHEN I SAY NO ITS OK,
PLZ ADVICE
Thanks
Bobby

hi,
was trying to delete that job its saying) cannot get exclusive acess to executable file for job )
plz advise
thanks
bobby