DSXchange

the warning messages is as follows

MappingofI002(xfm).#1.xfm (DateGenericToTimeStamp): Could not convert date/time :2002-04-05 00:00:00

this warining reapeats more than hundred times

Hi All, i'm here doing 3 jobs , one is server job for extraction and the other two parallel jobs for transformation. well here we have an sql script run on unix which extracts the data from the table and creates .txt file which has the data as well as the record count as the trailer record. well thi...

Hi All,

Well i have this Field which is of type varchar and i need to convert it to internal format .
i know i can use iconv function
but my problem is the field is in this format YYYY-MM-DD HH24:MI:SS

now how do i use the iconv function for this

Thanks in advance

Well unfortuantely i cannot use the Parallel transformer as there is some problem with the parallael transformer here.
hence forth i cannot make use of those functions available in the transformer . i can only use basic transformer.

Any other way out to do this?

Thanks

Well i need to convert the data type of the field from varchar to Int of lenght 8
and also from varchar to data type Date of length 8

what is the function i need to use for this in the modify stage?

Thanks

Hi All, I have this job where i am getting 32 fields at the output . these fields later has to mapped to a fields in a table most of whose data types do not match with these . well the data types of all the fields in the output are of type Varchar and of different lengths. well some these should be ...

oops i'm sorry it was my silly mistake. i dint pay attention to the property in the stage tab where i had given continue if not found .

i figured it out
anyways thanks

Hi All, I have this simple job where i'm doin a lookup on one file. but output here is a bit wierd. i'm actually doing a lookup on one field called MATERIAL which is of type varchar and length 18 . the output i'm getting is not right as the output is getting few Material values which id not present ...

well the job design is as follows i need to join 4 files the first join is between the files Kit_Param and Offer_Pcking this join is done based on the keys Offer_Id and Promo_Id here i'm getting few fields from the Kit_Param file and few from Offer_Pcking file the key columns are mapped from the off...

i'm doin a hash partinoning and the key fieldfs are the same as the keys used to join the two files.

ie the Offer_Id
and Promo_Id

No i havent changed the data type nor the length . it is the same as what it is in the source file. well the sample data at the source is here below Promo_ID Offer_ID Buy_Cart Get_Cart CTN_CONFIG_NUM_DEALS CTN_CONFIG_NUM_FREE_FLOAT 00003453 00005263 1 1 0 0 00003507 00005320 0 1 5 0 00003549 0000534...

Well there are matching records , that is why the other fields are displaying values . only this field is not displaying values.

Any Clue why this is happening ?

Hi All, Well i have this job where i am joining 4 different files at different stages. well the first two files are joined perfectly and i use this output file to join with the 3rd file . here i am haveing a problem . well i have this one field in the 3rd file which has values but after i join this ...

i actually need to do that itself. well i want the field to be displayed as Null if it is Null so that i get to know which all records have null values. and more over the parallel stage transformer here is not working . hence if at all i need to use transformer i can only use basic transformer now c...

Hi All, I have this job where in at the end of the tranformation there are few fields which are displaying as blank , which i guess should be null . well i want to reploace those blanks by "NULL" how do i do this in modufiy stage well i used the function CTN_CONFIG_NUM_DEALS:string = NullT...