DSXchange

hi all,

I would like to know when does the version of IBM DataSTage 8.5 support end? do anyone of you have link to the IBM site or info on this?

Sai

Hi,

I wanted to know if there is a reason why The Netezza Connector does not have a reject link. Or am I wrong? Does it have one?

The Teradata connector has a reject link which was a good way to capture any rejects during Load. Any reason why Netezza does'nt have this?

Sai

Hi, Are you on DB2? I have just completed working on DB2 Pure XML and this really works great. Its lets you store the data as a XML data type natively in the DB and you write XPATH queries to parse the data. It is pretty simple with some learning. Here is a good document that explains it http://www....

Thanks to Vincent, Ray and all others. I am glad on all the answers and far more assured about the way foward. Thanks again

This has been a long standing discussion of mine(with my Colleagues) about understanding and equally leveraging the DB and DataStage

Hi all, I know this may be a primitive question and i think i know the answer. Scenario: Joining data between a DataSet and a table that exists in the database. In this scenario if i sort the data in the databse using order by, do i need to still sort the data in DataStage? As i far i understand it ...

Hi,

Change the "Write Mode" to "User-Defined SQL". This is a work around, that should work fine.

Regards

Hi All,

I have a crazy requirement where in i will have to ready wider file having more then 2200 columns using a sequntial file stage. I would like to know is there a threshold to the no: columns that can be read by a sequential file.

Any help is appreciated!

Regards,
Sai

Hi,

I would like to know if using the universe tables i can get to know if a Db2 stage is being run in Sequential or Parallel mode?

Regards,
Sai

Hi Ray, Following are my test results Db2 Udb Load Stage: By default this runs in sequential mode and as the number of records increased it was proving to be slow. And i would not recomment this stage unless you are totaly comfortbale with the stage properties. There are quite a few stage properties...

Hi All, I would like to know the difference between the Write (load with Append) option in Db2 UDB Enterprise Stage and the DB2 UDB load Stage? If i am not wrong both invoke the Db2 load utility and work the same way except for a few options in the stages. In specific i would like to know whether, -...

Hi Ray,

I have one more question. May be i am confused. In 8 i assume that the Transformer stage still generates a C++ code and in addition uses an efficient transform operator as compared to 7.x

Regards,
Sai

Hi Ray, Thanks a lot for your answer. Does this mean that as compared to 7.x, in 8 i can use as many transformer stages as possible without affecting the job performance as in 8 the transformer stage compiles to an efficient Transform operator? Including simple transformation like dropping columns, ...

Hi, I believe the Transformer stages are haevy compared to other stages like Copy or Modify etc. Has this changed in IBM InfoSphere DataStage? In the "Parallel Job Advanced User Guid(7.5.1)", it is written that we shoud use transformer stages sparingly and use other stages such as filter s...

Hi All, I would like to know the differnce between a Parallel shared container and "Allow multiple instance " jobs? In parallel if i am not wrong, "Allow Multiple Instance" will use the configuration file and run the nodes. So there will no sharing of resources? For Shared contai...

Hi All, I would like to how does a truncate command behave in each of the database stages DB2 Enterprise: Does it use the load and replace option to truncate data or does it do a delete from <table>. Also by default will this commands be captured in the redologs Oracle Enterprise. Does it use the Tr...