DSXchange

add env variable APT_NO_SORT_INSERTION= true as job parameter and test ur job...with partition as "same" thru all the stages

u didnt get my msg..assuming field colA has length 5 on the table. Now while loading the table, there must be some formatting standard..(e.g., for char fields ..trim leading and trailing spaces, then left justify the column and fill the remaining bytes with spaces "abc ")...now u have a re...

If I were you, I would have made the columns of same length, by doing formatting (like trimming, left justify space filled) for both LOOK-UP and MAIN Stream. Before bringing it to look-up stage.

My understanding on the subject is: Assuming I have 50 columns and I have 10 stages in my DS job (with stage 1 as input file stage and stage 10 as output file and 2-8 are some intermediate stages) . Out of 50 I am using only 10 columns for some logic and rest 40 columns are straight move. In such si...

You have two link going to your Join stage, both the link has "EndProcessingDate" column and this column is not part of "KEY", on which you are joining the two links. Soln: either you drop the column from either of the two link before the join stage itself or change the name of o...

if you want to read the last rows from the source file, you can use "external source" stage and then use unix command to get the last row.
tail -1 /#path#/filename.dat

I think you can simply make the field as nullable, in the metadata of all the stages and later while writing the records to a file, you can set a default value in fields properties in sequential file stage.

There is another way of doing it.

Right('00000000000':<link.column name>,11)

Hi All,
a quick question. How to Right justify and zero fill; a string in PX?
An equivalent of FMT(ColumnName,"11'0'R"), in PX.
I was looking for functions, but couldnt find one. Px has PadString function, but it does Left justification.

Hi All, How does a hash file handle duplicate records. My understanding is that if a hash file has a key, then a record coming in with the same key overwrites the existing record. If it doesn't have a key, then it keeps the incoming record even though it is a duplicate. But does it make sense to st...

Cause: The SHUTDOWN IMMEDIATE command was used to shut down a running Oracle instance, terminating any active operations.
Action: Wait for the instance to be restarted or contact the database administrator

In short,
for comparison have UPCASE(Src.Name)=UPCASE(Lkp.NAME), but while writing the field, dont do any transformation, simple one to one mapping(do not change case)

Sorry I forgot to write, Var = MyRoutine('2004-01-01') inside a routine. The answer after compile it is "Array MyRoutine never dimensioned." You got the above error while compiling the RoutineB because, you have not specifically given directive to compiler that 'MyRoutine' used in RoutineB...

say you have routine RoutineA and RoutineB.
RoutineA has 2 arguments, filename and filepath.

Now you want to call RoutineA inside RoutineB.

RoutineB

Deffun RoutineA(A1,A2) calling "DSU.RoutineA"

var1=RoutineA(value1,value2)
------
-------------
----



Return(Ans)

ysrini9, Could you please give more details, what do u mean by valid? will u be comparing the format for validity or will you be comparing it with some default value? Second part of your question is even more confusing. If possible rephrase your question and explain your requirement with an example....