DSXchange

devanars wrote:I dont think so seqential file will work for rejected link. It will work fine if you use only Peak or Hash file.

We're in the parallel job world here!

All of the routines supplied with the product are server routines. You can not uses these in a parallel Transformer stage (though you can use them in a BASIC Transformer stage, but this may be frowned upon at your site). Incidentally, m/d/yyyy is not a "generic" date. Read the documentatio...

The install progress indicator is just plain wrong. I did an install yesterday and it progressed erratically up to about 60% and then jumped immediately to "Finished". And that was a "select all" install. (Alas, I did not keep track of how long it went; I did some documentation o...

Begin by creating a stage variable in which you apply an Upcase() conversion to the incoming customer title. This will allow your comparisons to be case-insensitive. A suitable column derivation would then be: If Index(svCustomerTitle, "OCCUPIER", 1) > 0 Or Index(svCustomerTitle, "CUS...

Are you missing a dot between the (parameterized) schema name and the table name? How come you have a parameter reference in the repository anyway? Query DS_METADATA to see whether you can find this particular record.

There is also the NLS.ADMIN menu in the UV account, but it effectively executes the same commands under the covers that you did.

What do you mean by "work"? The sequential file stage does not care what its field names are called. But there is no solution for an arbitrary number of fields in the server Sequential File stage (because there is no "Schema File" property and no runtime column propagation. Simil...

It was announced, following a very heavy-duty disclaimer, as a "future plan" (not necessarily in "the next release", not necessarily able to be implemented) at Information on Demand 2008 conference last October.

Good luck. As far as I am aware the minimum licensing is ten seats.

Maybe the community needs to make more noise about this one?

Then I fear you will need to engage someone, such as your official support provider, who can deploy investigative skills on your actual site. There is not enough information for me to make even a guess.

Actually, you CAN do this if you treat all the columns as VarChar, and use generic column names (sequential files don't care). Just make sure that you have as many columns named as the maximum possible number, and replace any missing columns with "" or NULL. Hashed files are permitted to h...

Everything else is not the same. For example sqlldr's parent directory can not be found in the command search list on one system but can be found on the other. (The command search list is also known as the PATH environment variable.)

Please mark this thread as Resolved using the green button at top.

I don't mind using more than one Transformer. You can always hide them in a local container. Call it "Magic_Happens".

If it's any consolation, a lot of server developers making the transition hate the way that parallel jobs strictly enforce data types!