DSXchange

I respectfully request that you either read the documentation or browse the threads here to get your question answered. "PX" stands for "Parallel Extender".

The word "neone" doesn't exist in English. This is a full-text forum, not an SMS one.

prasanna_anbu - The question you asked has little to do with the thread, so it is best posed in a new thread - and since you have already done that, it won't get answered here.

What is your value of LKP_To_TFM_Check_Null.transaction_dt ?

DataStage PX Jobs do not limit the number of rows read. It is possible to use a transform stage and filter by using the @INROWNUM value of the record, but that can get complicated by using multiple nodes, as each node will start counting at 1. It is simpler to actually create several input files, ea...

There is no reason to open up a new thread for the same subject, even if none of the answers you received satisfied you. There is no easy way to compute that all your columns are distinct. This would be a case for coding either a build-op or writing some BASIC code. Since I am more conversant with B...

Don't delete anything in project directories from UNIX . You have now ensured that next time any of the jobs are compiled where you have deleted the temporary directories you will get fatal errors. Most likely you will have to backup the jobs in question, delete them in DS and then re-import them b...

INT(In.Column*100)

Those tables don't exist in the XMETA repository, but remain as hashed files in the local DataStage.

So what if they say that. BASIC Transformers are part of the product and need to be supported.

Do you have an NLS installation? Also, what character set is the string data in (and which Japanese set might be used for Kanji/Kana)?

Test cases are always job/data dependant so you won't get any exact information from the forum. You should always try to put together test cases with as many combinations/permutations of possible data as is likely (or perhaps unlikely but not impossible) to occur during production.

You will need to provide a bit more information on the error messages and what has happened before someone can give a possible cause.

What kind of a job is "abc.LOAD11"? Is the error message you posted coming from a sequence calling that job?

Declare a column called UNIQUE1 as "C1:C2:C3:C5", UNIQUE2 as "C1:C2:C4:C5" and mark both of them as keys.

Hashed files work by converting the record key into a numeric value; this is the number of hash "buckets" that the file will have. When reading, once a key has hashed into a bucket the contents are searched sequentially to find the actual key and reference to the data. If a bucket is grossly overfil...

Bikan, once you know how an XML file is formatted and how you wish to structure your XML from the source file the actual steps involved in DataStage to do this are easy. But you need to understand what XML structures are and how a file is built up before you can do this. I would recommend first brow...