DSXchange

Thanks for reply.
And for number?
If the lookup field is nullable what does it happen?

Thanks!

Hi, In the lookup stage I have 4 options if the lookup is not found. The options are 1. Continue 2. Abort 3. Reject and 4. Drop. If I use the first option and say to continue a null will be passed to the output.... The null values dipend on the column lookup format? Because If the lookup column are ...

I have the following problem while trying to update table from a sequencial file : Sequential_File_123.L_Update: Error when checking operator: At field "N_DWH": When validating import/export function: APT_GFIX_Decimal::validateParameters: Decimal "text" format is variable length ...

The problem is that the record with null values are doscarded and not written in my file. Why?

[quote="Eric"]look at the columns list in the sequential file and double click on the row number (left hand side), this brings you up another screen that allows you to set the -> Nullable -> Null Field Value. This allows you to set the character string you are using to mean NULL that is wr...

Hi, I have a job: Oracle extraction - file sequential. Some fields are nullable, and I want them null. But I have some discard, the message is the following: Rss_Consistenza_file.Estraz,0: Field "FIELD1" is null but no null export handling is defined Rss_Consistenza_file.Estraz,0: Export u...

Thanks

I have the following error while compiling a job (file - trasformer - file): Anyone could hel me? :cry: Thanks! Output from transformer compilation follows: ##I TFCN 000000 17:37:40(000) <main_program> DataStage XE Parallel Extender V6.0.1 Copyright (C) 1997 - 2002 Ascential Software, Inc. All Right...

Hi,
I have a problem with a lookup step, the error is:
Lookup2,21: Could not map table file "/dstageeetl1/DataSet/lookuptable.20050302.b3j3ypb (size 1183357452 bytes)": Not enough space
Lookup2,21: Error finalizing / saving table /tmp/dynLUT43555482be25

How can I solve it?

Thanks!

When i am trieng to compile a parallel job it is giving the following error. My job consits of three oracle Enterprise stage as source one transformer and sequential file as target, it is direct mapping from source to target, there are some stage variables. Output from transformer compilation follow...

What does mean the following warning:
[i]input1.DSLink43:
When checking operator: Column num_dw floating point decimal
not fully supported. Adjusting scale??[/i]
In Input the field extracted from oracle is a decimal field (num_dwh) without scale!

Thanks for help!

Thanks for your help!

Hi experts!
what is the optimal sizes for array? AND transaction? Is There any criteria to decide array sizes ....to load a table with 15 million of record?

Thanks very much

what does mean the following error in lookup stage:
"...When checking operator: Input Dataset 1 has partitioning other than Entire specified; disabling memory sharing"


Thanks in advance!

Hi,
I have a problem with my project, I can't view,edit,export my jobs...I get the Repository Interface pop-up:
"This item has no design time information"!

Help me!!

Thanks!!!