DSXchange

Hi

Can someone explain me the combination of lookup conditions-

condition not met lookup failure

continue continue
drop drop
fail fail
reject reject


Regards
Arnie

Hi,

I have got a decimal field EXT_AMOUNT DECIMAL 11,3. I get the values as 00000000045.22 whereas I need them as 45.22. It is a file load.
Please let me know how to do it.....I have already tried a lot......

Regards
Arnie.

Minhajuddin wrote:Search the forum for this issue on "Non-pipe", It has been discussed a lot of times.

Got it.....it was becoz of wrong parameter in the DB2 stage......

Thanks
Arnie

Hi,

I have a small doubt.

If we do an inner join on the basis of dummy column then the records get duplicate as it will do a cartesian product.

Is it same in the case of left outer join.......can we get duplicacies???

Regards
Arnie.

Hi,

I have got a fatal error for which the job aborts.

main program: Dataset,file set, or file"Transformer_306:In_Jn_StoreMaster_Ref.v":Non-pipe(or non virtual dataset) with .v in its name.


Please let me know what is causing it and how to resolve

Regards
Arnie.

ray.wurlod wrote:Point 1: diagnosis is nearly impossible while operator combination is in effect. Lose it.

Point 2: why Unicode?

Point 3: what is the format of TRAN_DATE, and what is the format string in your d ...

Its coming as unicode from the database............

Its format is yyyy-mm-dd..........

Hi, I am having a problem in String to date conversion in transformer stage.There I have put a peek stage and found that the date field is getting converted to ********. And the warning that I have got is: APT_CombinedOperationComtroller(1),1:Conversion error calling conversion routine date_from_str...

Hi,

Can we filter a record where the length of a particular field id >5.

I have used Len(EMP_ID)>5 in the where condition but I am getting error.

Regards
Arnie

Hi, I need to get the previous date (Current date - 1) in stage variable. How to get it. Pls help me. Sura Can do this way.... Take two stage variables Stg1 and Stg2.....initialize as 9999-01-01 to both. If Stg2<>Stg1 Then Stg2 Else Stg1-------->Stg1 and Input latest date field --------------------...

If EMP_ID can be null from source you must handle this explicitly. Functions such as Alpha() and Num() can not accept null arguments. Calculate stage variable svEmpIdTest as follows. If IsNul ...[/quote] The null is handled and EMP_ID is coming as unicode so I have done UstringTostring on it. The e...

Hi, I have got a problem in the constraint part.Here I have to pass only those values from the transformer whose 6th letter is char and 5th letter is numeric. The filed is EMP_ID varchar 30. I have used Alpha(column[6,1]) and Num (column[5,1]) in the constraint.Now no records are passing and its thr...

Hi,

I need to insert the new records into the target. In this case I can use either a Join stage(left join) or a change capture stage.

Please let me know which is recommended for better performance.

Regards
Arnie.

Is it possible it transformer stage??

regards
Arnie

Hi

I have got a varchar field. The records coming are like 0000006.50 and I want to get only 6.50. How is this possible?

Regards
Arnie

Hi

I have got a varchar field of length 12,2. When data(say 16.25) is populated in it comes as 000000000016.25.

I want to get it as 16.25,without any zeros being padded in left. Please help.

Regards
Arnie