DSXchange

I have file structure same as DB table. For me no need of using any Constraints or derivations or RejLink. seems Except BEST PRACTICE it doesn't matter much. Okay Thanks. nsm. I would say it matters ALOT. All of those issues are exposures, when you're losing rows and don't know it you'll be wishing...

The components of a hash file are the VOC entry, the D_xxxx file in the project, the subdirectory xxxx, and the 3 files therein. Make sure you delete the file system components since you've hijacked the VOC entry. One thing to keep in mind, if you created this file using a UV/ODBC stage then there's...

A transformer allows you the ability to manage the order of columns processed, important because your SQL statement will be directly tied to the order of the columns in the file. A transformer stage gives you mapping ability to set the columns in the order you wish. In addition to being able to deri...

Well, first of all, hash files are UNORDERED. You should NEVER use @INROWNUM as a means of reading a hash file and expecting it to return consistently ordered data unless you're using a UV/ODBC stage to give you a SQL interface and use an ORDER BY clause. Second, how are you invoking sqlldr? You nee...

What are you trying to do? Are you using a stored procedure to return streaming data to a DS job? Are you using it for a reference lookup? What's the syntax of your CALL statement? Have you debugged the stored procedure?

There is NO capability within DataStage to do what you want. What you CAN do is control the bulkload operation yourself using intelligent scripting. Oracle's sqlldr generates a log file that you can parse to get the last commit point. Then, you can run the sqlldr load with a modify control file inst...

The Oracle stage adds to_Date(columnname, 'YYYY-MM-DD') to your column in the auto-generated SQL. If you're using auto-generated SQL, then make sure your date value looks like YYYY-MM-DD. Using DATE() returns the internal date format, so use something like OCONV(@DATE, 'D-YMD[4,2,2]'). If you're usi...

Sorry, but Kim got the answer out before I checked back. Yes, 1.0 was the first version, but 3.5.3r3 was really the first stable version that really had its act together, with a good transformer stage and hash-caching disabling and decent ODBC and OCI stages. The problem was my hands typed what my m...

Just get the readme files from each version's install cd. You'll see the product changes from each release. By the way, the changes between each major version have been HUGE. From 3.5 to 4 the product added MetaStage to the picture. From 4 to 5 the product underwent Universe --> DSEngine separation....

Hey Kim, yeah, had a bit of a tough day. Tampa Bay Lightnings won the Stanley Cup last night so I'm a little sleep-deprived. But, my points still stand and thanks for the kind words. TJ has joined Ascential, so we won't be seeing him around here anymore because of prohibitions on posting in forums. ...

If all tables have the EXACT same columns - ordinally, data type, and length, but the NAME of each column is just different... Load a representative set of metadata and try just USER-DEFINED SQL doing a "SELECT * FROM #tablename#". I don't think you're going to need to name the columns - user-define...

Do you have access to DataStage and can actually experiment with the tool? Consider reading Ralph Kimball's Data Warehouse Lifecycle Toolkit for an introduction to where ETL tools generally are used: data warehouses. As for forums, this forum is for users of DataStage to exchange ideas, concerns, ti...

It's not about touchy. This subject has been covered before. It you aren't qualified for the job, don't come here to try to cheat and get answers for experience you haven't gained thru effort. My side rants are the effect of a cheater impacting myself and a bunch of others who have killed themselves...

James, respectfully, isn't a technical interviews purpose to expose the knowledge of a candidate and hopefully prevent the company from bringing in an unqualified candidate? It sounds like the interview served its purpose. You need to search this forum and try to glean answers in lieu of asking us f...