DSXchange

Are you talking about a .dsx file?? No, you cannot. I suggest you investigate the Reporting Assistant, MetaStage, and other tools for bringing metadata out of DataStage.

Use the DS Manager tool and attempt to import ODBC table definitions. Only by doing that does it populate the drop down lists in Designer for "known" data sources. You MUST ALWAYS IMPORT TABLE DEFINITIONS to make sure you can: 1. Talk to a database 2. Get the correct metadata 3. Have access to a giv...

Verify the permissions of the project directory, the dsenv file, the umask setting in the ds.rc script, etc. Your userid is probably running into group/permissions issues.

99% of first time access problems relate to permissions.

From the Control Panel, Administrative Tools, Data Sources(ODBC), setup a System DSN using the SQL-Server driver. If you setup this correctly, then DataStage will be able to use it.

Your problem is not DataStage, it is your configuration.

Please only post once in the appropriate forum.

Your concept is flawed in that you wish to open files exactly where they sit. How are you managing whether the file is being manipulated, potentially deleted, etc. during your runtime? You should copy the file to a working directory and process it there. By executing a copy statement, you avoid your...

I use DataStage but on my own notebooks. And I would like to know what is the performance on the really huge system with a lot of RAM and CPU. You cannot even begin to write an equation that can take into consideration all of the variables involved. A Windoze PC cannot even compare to an 24 cpu SMP...

Search the forum. Information you require is available and goes back years.

Here's my own version I wrote for an after-job routine. It is fixed at 10 output files, but that easily can be a calculation based on the size of the file: DEFFUN WordCount(FileName) Calling "DSU.WordCount" SplitFactor = 10 InputFileName = InputArg WriteBufferCacheSize = 10000 Rout...

They have the same records number of 24 millions with the same key fields key1, key2, key3. each file has average 50 fields. This is going to be brutal. 4 files X 50 columns merged together = ~200 columns. This row is so wide you are going to take serious performance penalties reading all of these ...

You have to import the table definitions using DS Manager, then load those definitions into the OCI stage. In your transformer, map the incoming values from the file to the equivalent columns in the outbound link going to the OCI stage. You MUST use the target tables definitions as loaded by DS. Nev...

Take another RT_CONFIG file/directory in your unix project and copy it to the errant/missing name. This will at least allow you to import the job or delete it. As I keep telling everyone, it's BAD to run out of disk space on your project.

You ran out of disk space, you have orphaned pieces and parts of a hash file. Export this job and re-import it.

It's an inherent stage variable. It lets you know if the link reference lookup found a row or not.

dsrules wrote:Kim, dont you think those questions were in bad taste?
...
What does Ray, Ken, Chulett and other guru's have to say about this?

I was letting my silence speak for itself, until you invoked my name. Yes these are interview questions. New user, first post, reads like a tech'ing cheat to me.