DSXchange

Hi All, Well i have this job where i am doing a lookup of as seq file with the oracle table in the transformer. well the reason i am using the oracle table is i have a certain query to to fulfilled. well heres my query SELECT Count(*) as Count, ZZKITUPC, PROM_FROM, MAX(PROM_TO) FROM ETL.PRODUCT_PROM...

Hi all, This is just a general question . i was curious to know why and where can we use the compress stage. well i tried going through the documentation that comes along with the software but dint get to know where exactly is this stage used or rather how would the output of the stage look like. Co...

Well the extact warning is this cc_Rtl_Accounts: When checking operator: Defaulting "EXTRACT_TIME" in transfer from "beforeRec" to "outputRec" cc_Rtl_Accounts: When checking operator: Defaulting "EXTRACT_DATE" in transfer from "beforeRec" to "ou...

the run time column propagation is already disabled.

any other way to get rid of these warning..
plz help

Hi All, I have this job where i am doing a change capture . well i have about 6 keys on which i'm doin change capture with all the fields being sorted in ascending order. and i have used and i have used change change mode to be Explicit keys and all values . and i have given two fields as exclude as...

Thanks

I did that way and its working

Thanks once again

Hi All, i have this job where i have field which should get the next date of a particular date field. well all the fields here are of type varchar i used the function in the basic transformer to get the result convert("-","",DATE.TAG(DateGenericToInternal(Left(Convert("-&quo...

Hi All,

Well i have this job where i am doing s look up and i have few rejects based on the lookup keys . The rejects are stored in dataset file.
now i need to get all these data into an excel sheet .
how do i do it ?

Help on this one please

Thanks in advance

Thanks DSGuru,i guess that part is taken care of now . but have the isssue still with the date Well as i already mentioned the function DATE.TAG(DateGenericToInternal) not been able to handle the date after nov 30 as in why doesnt it give it as dec 1st . is it that the function is not functioning pr...

i also have another warning which says Lookup_40: When checking operator: Dropping component "Packs_Per_Carton" because of prior component with same name what does this mean here in this job i'm using join stage is this because of this stage , if so how do i get rid of this warning Thanks ...

Thanks Kumar for the clue. well i checked that particular field and i guess i had made a mistake in giving the function properly . i had actually given convert('-','', DATE.TAG(DateGenericToInternal(l_Modified_I002.SI_CURR_END_DT)+1)) actually i wanted this field to get the next date of that particu...

let me answer one by one well the conversion is required as the destination filed is of type char in BW i need basic transformer as i cant use the parallel transformer since it is not functioning properly here as i already mentioned paralle job could recodnise the "|"(pipeline ) as delimit...

well the all smilie should have been 8 in that post

Sorry about that .
well the field is of type varchar(38)
and now should be converted to type char(38)

well no where i have used DateGenericToTimeStamp
but i have used DateGenericToInternal for one of the fields as i had to add a day moe to the previous date.

and i have givne the function this way
convert('-','', DATE.TAG(DateGenericToInternal(l_Modified_I002.SI_CURR_END_DT)+1))