DSXchange

"Hello There"

Hi , Could you please help me in removing below warning from my job.... I am not able to understand ..why this warning is coming? Lkp_Validation,0: When binding input interface field "T_PROD_INFO" to field "T_PROD_INFO": Implicit conversion from source type "string[max=20]&q...

I want rejected records from both source and reference......

full outer join will not give only rejected one.....

That gives source rejects what about the records from reference link?

IS there any condition i can set?

How can I get records rejected at reference link....
I can get the records from source but is there any way to get reject at reference link in Lookup stage?

Thanks
SD

Hi ,

from my souce I am getting date like '2010-04-16-16.08.02.945000'

I want to convert it into the yyyy-mm-dd format

is there any function available to do this?

My source is a csv file.

You can use Tr command to remove control M character... in the before job subroutine....

You have to design your job accordingly

Hi
I am also getting same warning... in OCI stage....
What can be done to remove it...
What will happen if i ignore it?

Hi, I need a help regarding a requirement... I need to design a job where I have Three files which will arrive in a folder..I need to create a simple job which will read all the three files one by One...and load datainto final table...but each column should be flaged with the file name from which it...

I am using "OS Level authentication"

Hi, I have a job which in which I am extracting data from Oracle and loading into oracle again... here i am not passing the parameters for User Id/Password.... I am taking these credentials from System only..... I want to know if I change my password will my job fail or still it will work fine.. Tha...

Hi, I have a very simple job.... Oracle stage ---> trasformer --- > Seq. file stage... I am getting below error... This job is scheduled in a sequence....the sequence in terns calls many routines.... I am getting below error for this job.... DataStage Job 604 Phantom 2104 Aborting after 1 Rows writt...

Well..this was being asked by one of my friend...So i was curious to know..how to achieve this...

how?

Hi , I have a job which has three stages.. The second stage is not a trasformer stage...all i want to achieve is 3rd stage should be triggered only and only when there is one row coming out of second stage.... is there any function to achieve this? (I am not using any job control or sequencer...) Th...