DSXchange

Yes. Your understanding is right Ray.

Any idea on how to achieve this.

Thanks,
Srikanth

Hi, I have 5 columns in the source table - table 1 Lets say Key, col1, col2, col3.... col5. I have another table with just 1 column and this column has all the column names of first table as records (except the key). So, there are 5 records in the table2. I have one more table which has some 3 colum...

Hi Everyone, I observed this many times. When i load data from a sequential file to oracle using a OCI stage the data is not getting loaded in the same order in which it is available in the sequential file. For eg: sequential file has records like.. 1990 Q1 12 1990 Q2 13 1990 Q3 12 1990 Q4 13 1991 Q...

Craig,

Thanks for the reply.

I am on 2000 with SP4. This problem comes on 2000 with SP3 also.

For 2000 what is the service pack i am supposed to have?

Thing is the problem comes only for the routine activity. All others activities are working fine.

Regards,
Srikanth

Actually we got this problem fixed. It is bug on Ascential side. The technical support team provided us with a new dll for the sequencers. We replaced the old dll with this new one and this unknown exceptions stopped coming. The desiger is more stable now when working with sequencers. But the new dl...

I had the same problem mentioned by gangeleri. In datastage my job rans fine and the status changes to finished. Even the performance statistics show that the records have been loaded into SAP. But in reality no data has been loaded into SAP table. Our SAP developer set some alarms to find if the da...

Yea. Checked it. There is not much of change in memory usage when the error comes. Rest of the jobs are working fine. only when we open sequencers (that too considerably big ones) we get this error. The same sequencers used to work fine in 7.1. Not sure if this version 7.5.1 is working fine without ...

We are getting strange errors after upgrading to 7.5.1 from 7.1. When ever we open sequencers that are quite big (probably some 40 to 50 activities) and just try to do a couple of changes (can be anything just parameter changes or trigger changes) we get a weird error and the designer simply crashes...

I have a job extracting data from SQL Server and loads into SAP using BAPI plugin. I don't find any option like transaction size in BAPI plugin stage. My job is making a new BAPI call for each record processed. I don't want that. I want to make just one call to the BAPI and send all the records to S...

Thank you Ray!

Hi, Can anyone explain me the difference between OCI, ODBC and Oracle Enterprise stages? I know how to use these stages. But I am not sure what happens in the back ground process of Oracle Enterprise stage (which is used only in PX) and OCI stages. Is there any performance difference in them? How do...

To add more to my above post... the job used to work fine earlier when the target column is given as varchar(4000). But at that time the DS version is 7.1 Last week we upgraded datastage to 7.5 and i found this problem. Is it something to do with upgrade of datastage to 7.5 or is it some problem wit...

Hi, Even though i don't get the above error i have a problem with Varchar(4000). We use Oracle 8 with DS 7.5 version. I am trying to load from source to target with out any transformations. Just a plain mapping from source oracle to target oracle using OCI stages. One of the fields is Short_Descript...

Hi Akash, It is very much possible to have a single sequential file for multiple rejects using funnel. But make sure that all the reject links have save same metadata and collect them in a funnel and pass them to the sequential file. To identify the reject link from which the row is rejected (this i...

Hi Roy, APT_CombinedOperatorController,0: Field 'field name' from input dataset '0' is NULL. Record dropped. Whenever the key columns in the lookup is null this warning comes. It's quite common and we used to get this warning in our jobs. can't I pass it along the same link as regular lookups that w...