DSXchange

Thanks a lot Kumar.My problem is resolved now.

Hi All, My requirement is to Populate only number for a column which can contain alphanumeric.The length of Column is 24 and dattype is Varchar.number and alphabets can come at any place. Ex..if data is coming like hfkhfh12hje4344jbd4j then i need to populate only 1242444. or if input data is hjdghj...

Thanks a lot for this great Suggession.I will take care of this in Future.
As I Understood if i will set APT_STRING_PADCHAR as 0x20 and then trim the column RECORD as Trim(RECORD) then we will get [Ready ] as [Ready].Right!!!

Thanks a lot Nagesh,
I am not aware of this Environment Variable called APT_STRING_PAD_CHAR.can you please explain what is the functionality of this and what it does.


Thanks in Advance.

Hi Kunal, Just remember, whenever your doing lookup the filed datatype should be same in both Main stream and reference stream. here Length is a problem , when ever your performing lookup on CHAR to CHAR field. Length is not at all a problem when you are performing lookup on Varchar to Varchar fiel...

Thanks a lot Shantanu for your quick and kind suggession.
I am already doing the Trim of Lookup column as well as main Stream.Is this any Unicode data problem??

Hi All, In My job i am using one lookup table based one column having length Varchar(12),but the actual data is coming of length 8.I am trimming that field at oracle and then doing the lookup.When i am making length as 12 all data are getting rejected at lookup,but if i am giving length as 8 data is...

Hi Ray,
Actually i was not aware of that fact.from now on i will definitely take care of these Etiquettes.Thanks for your guidance.

If you are not having too much data can you please check if there is any duplicate record coming after joining two files???if yes! and you are not handing that using remove duplicate stage then the problem can be this one.

Are you performing any calculation at transforming level???

I think you can do this by converting your fields as datetosting or timestamptoString and then compare themn.I think this will work

I think i cxan help you on this,but can u please explain your requirement in simple words [DEP_DATETIME BETWEEN CAST('2006-10-12 00:00:00.000000' AS TIMESTAMP) - 28 DAYS AND CAST('2006-10-12 00:00:00.000000' AS TIMESTAMP) - 21 DAYS THEN 'N' WHEN DEP_DATETIME BETWEEN CAST('2006-10-12 00:00:00.000000'...

I think there is no other way out .... .i need to do it in the transformer using IsNull function for every column separetely.

The problem is... data is getting rejected at transformer stage.and i am getting warning message as ...[APT_CombinedOperatorController(1),0: Field 'PROCESS_DATETIME' from input dataset '0' is NULL. Record dropped.]

Thanks GURU,
But this constrain is for around 100 fields.conversion like
Timestamp to Char
Varchar to Char
Decimal to Char etc are there.