DSXchange

Hi All, I have a requirement which is i am getting some status like COMT,PEND,FAIL,NULL from my source file. what i need to do is i have to filter the status and send it to each file. so i had used one switch stage to filter the status, but NULL status is not recognizing in SWITCH stage? If any NULL...

Hi,

Can any body reply to above question?

thanks

it is word 'NULL '

Thanks for your reply ray..

I have tried both NULL AND is null but its not recognizing.

when i put the condition (other) in swith stage all NULL status records are going to OTHER file.

Hi All, I have a requirement which is i am getting some status like COMT,PEND,FAIL,NULL from my source file. what i need to do is i have to filter the status and send it to each file. so i had used one switch stage to filter the status, but NULL status is not recognizing in SWITCH stage? If any NULL...

Hi All,

Could please telll me the what is the default format of DSJobStartDate:

in my job its giving yyyy-mm-dd..

I want to convert into yyyymmdd. is there any way to do that?

could you pls suggesst me

Thanks,
Vijay

My Source table(Teradata) having only 89 records.
Target table(Oracle) having only 29 records which are greater than maximum key value.

As you guys are suggested i have used peek insted of Oracle(Target) that my job ran fine.

my job design
teradata ---> T/R -------> Oracle

Thanks,
Vijay

Thanks for your Quick Respondings...

I ran the job on Single node also i am facing same problem. job is still running...


Thnaks,
Vijay

Hi All, I have a job like I am extacting maximum key value from Teradata(source), i am just deleting recording from ORACLE table whcih are having more than maximum key value. when i ran this job its running, running..... Here i am using 2node config file. could please suggest me why my job still run...

Hi All, Can you please explain the meaning of below query. SELECT RUN_STRM_C, GDW_BTCH_ID FROM DR_RUN_STRM_OCCR WHERE (GDW_BTCH_ID > GDW_BTCH_ID). I am using above query in my oracl table , i am lookup this table into another table here GDW_BTCH_ID is the key column. when i am exequting that above q...

Thanks for your answers...

My Question is I want to make a job lock, but that job was not opend.

Is any idea?

Thanks in Advance

Thnak so much ...
It helps a lot

Hi All
How can we convert integer to string in Modify stage?

yes...its opend

How can we lock the job?