DSXchange

Hi
I am trying to perform truncate and load option

for that in ADMIN,
I am giving APT_DUMP_SCORE for APT_ORACLE_LOAD_OPTIONS

but still i am getting error

any suggestion

thanks
suresh

Hi while loading the 7th rec, In the transformer I want to store the column value of 6th rec and add that column value to 7th rec based on certain condition and populate it to tgt, Only thing is I am not getting idea as how to get the value of 6th rec which already populated into the tgt table just ...

Hi Deepak Can you please elaborate it

thanks
sai

can you please elaborate it

thanks
suresh

Hi All there are 10 columns in my target table, 9 columns are filled from source and 10th column needs to be filled by number sequence starting from 1 eg for load 1 for 100 records, the 10th column is populated as 1 thorugh 100 eg for load 2 for 100 records, the 10th column is populated as 101 thoru...

Hi All
I just want to know one small transformation like

I have the value "A12345" as src value
and it should be populated as "12345" in the target
ie the first char should be truncated and populated to the target

the job is parallel job

src:table/file
tgt:table

Hi My source column is char(10) and value is "2006-03-04"
Now My interest is to convert into timestamp 2006-03-04:00:00:00
can I get the exact syntax for this

src is dataset with datatype char 10
tgt is dataset with datatype timestamp


thanks
Suresh

Floor is used to get the previous integer value
I want the value after deciaml to be rounded to 2 places

HI I have a column say Employee_age,
I need to round it 2 decimal places
could any pls let me know the exact syntax
I can give a hint for better understanding

NVL(round(sum(Employee_age),2),0.00)

I can do all except the round function in the above one

thanks in advance

StringToTimestamp(DateToString(lnk_Lkp_CustKy_out.UPDATE_DT),'yyyy-mm-dd hh:nn:ss')


I have date so If I convert it into string
I might get for eg 1999-11-05 is the date
and the corresponding string is "1999-11-05"

could you pls help me

thanks

I used this one:
StringToTimestamp(DateToString(lnk_xfrm_column.UPDATE_DT),'yyyy-mm-dd hh:nn:ss')
but still not working

Thanks

I am sorry the date(10) and the corresponding timestamp(26)
If at all anything missing then should be replaced with 00:00
thanks

HI I have a column of Date(4) and needed to convert in the transformer to timestamp(26)
Could any one give the syntax for this

Thanks in advance
thanks for your time

Suresh

Hi Everyone I have got new problem, Earlier I thought of first name and last name only Now I have prob with middle name For example: From the source I am getting a name called "kenneth charlie Browne" in the transformer the name should get split into only two columns called first name and ...

Hi Everyone I have got new problem, Earlier I thought of first name and last name only Now I have prob with middle name For example: From the source I am getting a name called "kenneth charlie Browne" in the transformer the name should get split into only two columns called first name and ...