DSXchange

hi tony,
iwhen i have select statment from sql its fine but problem is in datastage
its simple transformation and i am new to this any way we can increase the performance
thanks
bobby

hi,
Source Target is oracle
Thanks
Bobby

hi,
i have ORDER ID 1001
AND OMC ID MCS1001
I WANT TO COMPARE 1001 TO BE COMPARE WITH MCS1001 SO THAT
MCS SHOULD BE TRUNCATED AND I GET ONLY 1001 in transformer
PL. INFORM
Thanks,
Bobby

HI,
I am pulling my data from source florida to michigan its too slow 28 record/sec its just loading to STG no transformation is there any idea
i can increase that flow.
Thanks,
bobby

HI,
THATS WHT I AM TRYING TO DO 2 OUTPUT TARGET
THNKS
BOBBY

hi , i am using INSERT INTO tablename (col1, curr_flg , start_dt, end_date) VALUES (myseq.NEXTVAL, :1, :2,:3); - in my first insert it insert 100 rows now i wanna update end_ date to start_dt when curr_flg is 1 i am some question 1) when i just do simple insert its like 300 rows/sec 2) when i update...

hi i am using source and target as oracle as oer req i have to do like this end_dt if job_id exist in the table set set the current inserted record to a future date 1/1/2500 ,retrieve the last archive record and set date to system date curr_flg if job_id exists in this table set the current inserted...

HI ROY,
well no i want to keep record of previous id ,
Thanks
Bobby

hi
i use this same clause
still red

IF DSLink59.CHANNEL_TYPE= DS THEN "B" ELSE IF DSLink59.CHANNEL_TYPE=D2D THEN "C" ELSE "X"

JUST WANT TO HARD CODE B AND C FOR DS AND D2D FROM SOURCE

Plz advice
Thanks
Bobby

Hi Frnds
i have my job id i want curr_flg on latest one as 1 and rest o

JOB_ID curr_flg
--------------------
HS2004129319142-1 0
HS2004129319142-1 1
please advise
thanks
bobby

HI,
MY SOURCE IS
CHANNEL_TYPE
DS
D2D

Trarget wanna be
RECORD TYPE
JU ST WANNA SEE SOURCE CHANEL TYPE WHERE VALUES OF CHANNEL IS DS WANNA PUT B AND WHERE VALUE IS D2D WANNA PUT C
PLZ inform code will be helpful
thanxs
bobby

HI Roy,
Boss can u write code plz .
Thanks
Bobby

HI,
MY SOURCE IS
CHANNEL_TYPE
DS
D2D

Trarget wanna be
B
C

IF DSLink59.CHANNEL_TYPE= DS THEN "B" ELSE IF DSLink59.CHANNEL_TYPE=D2D THEN "C"


THE ERROR IS RED IS THIS NOT RITE
THNXS
BOBBY

hi chuck,
thanks buddy i got it.
thanks
bobby

hi,
bascially i wanna append all new record to same fct_table from stg
i have one ETL_control key which take care of integration now when i try to append that recors the etl key says now duplicate etl key
how can i take care of etl key
thanks
bobby