DSXchange

It is possible within FastTrack to "Import from CSV".

Is there a command line to accomplish this? I am hoping to be able to automate the process.

I don't believe that will work, but do try it and let us know.

With only one additional level of redirection it would be easily done. The general function would incorporate a dispatcher of some kind based on the first argument value.

Never believe what View Data tells you. Look at the files with some other utility, such as UltraEdit or vi.

They're definitely not DataStage partitioning algorithms.

dssh is an exact copy of uvsh. This allows you to use either name. One day, maybe, uvsh will disappear.

The requirement is not clear.

You can read about these Oracle partitioning mechanisms in Oracle manuals or on the internet.

What's the actual value in a_pay (or similar) for the columns that work and the columns that don't work?

Right click in the columns grid of the table definition you have already in DataStage and choose Save As to save as a schema file.

I suspect you'll need to build this in to have it reported. The system variable @LOGNAME in an expression in a sequence should suffice.

pandeesh wrote:It's not possible in datastage.

Your proof?

I believe it is possible, but I'm not sure what you're asking. Could you provide a concrete example?

I agree with Robert. Another technique that accomplishes a similar result is to provide a disagreement weight override, so that disagreement drags the composite weight substantially lower.

Is this a query that is guaranteed to return precisely one row? If so, what you seek can be done by using a server job to execute the SQL statement and load its output into the job's user status area whence it can be retrieved downstream in the controlling sequence via the Job activity's $UserStatus...

Yes, at least for some databases. I have done this. A sequence reads the table definition from the system tables and constructs SELECT statement from these, and passes the SELECT statement as a job parameter to a job that makes heavy use of runtime column propagation. The job that constructs the SQL...

No other tricky rights of which I'm aware, but you do, as always, need appropriate permissions to do things. To delete a Data Set, for example, you need permissions to delete the segment files, to delete the descriptor file and (as part of that) to modify their parent folders.

The parallel Sequential File stage is notorious for not being able to handle embedded newlines. This is not pedantry - search back through the myriad posts complaining about it. Note that simplistic "solutions" such as using a shell script to delete the new lines don't cut it for me - I be...