DSXchange

ArndW wrote:Have any rows gone down the ODBC link in that time? If not, it is an inactivity timer and perhaps you could make your job write to a file and then write a second job to load that file to the table. ...

yes, my source is DRS stage which contains 60 lacks of records...

Hi,

I know that Links are for Data flow between Stages in DataStage,But in Parallel Extender Link shapes will vary ...Would like to know main Diifrences between them

Thanks in Advance
Srini.Y

Hi,

I know that Links are for Data flow between Stages in DataStage,But in Parallel Extender Link shapes will vary ...Would like to know main Diifrences between them

Thanks in Advance
Srini.Y

This job running 2 hr 20 mins afterthat job aborted due to "Timeout Expired" warning message

Hi all,

I load data from source which contains 60 lakhs of records.when i run that job getting error message as"ACCONTS_FACT:[DataDirect][ODBC SQL Server Driver][libssclient21]Timeout Expired".pls help me out.


Thanks
srini

Hi,

Could you please explain me about diffrent link names and purpose in PX?

Thanks in Advance

Thanks and Regards
Srini.Y

Hi , when I click on the some stages in my job,I am getting one meassage which says"(40503) A call to an OLE server has failed,or a runtime error occured within the OLE server itself" due to this I uanble open the stage properties. can anybody share the inf what does it really mean or doin...

Hi All, here i am joining two tables using(left-outer) Join stage, in which left table contians 4000000 records and right table 2500 records joining with Join stage .when I am loadind data into next stage(join) records are multiplied(Cardinality) and I am getting error message which says "APT_C...

1.Datastage manager is gone.
2.All Manager functionality has been moved into the DataSatge Designer.
3.New stages are added like i.e., SCD stage,Connector satge

I required the information ,How to migrate From Informatica to Data Stage migration.

Hi,

Any Function to get oracle Error Description in DataStage.

By using DBMSCODE we are getting Errorno:ORA917

Belong's that How to Capture Oracle Error Description as well

Please Let me know the way?

Thanks in Advance
Srini

Hi All, I have a requirement like below: Source --------Transformer------------>Staging || Rejectfile If data is got aborted and loadted in to reject immedi..I need to send a mail to respective people ? attachment along with Rejected Rows ? is there any possiblity to achieve in DataStage itself ? Ad...

Hi All, I have a requirement like 1 -record need to be split into mutiple columns Ex:Record:Batch 2|| incident ||casue||0001-10-09 00:00:00(Database) I need to populate data according the table columns ============================== Column name Datavalue ============================== Batch Batch2 g...

Hi All, Could any body help me how to takecare To spilt the year to Months in Datastage -------------------------------------------------- Year Rate --------------------------------------------------- Input : 012007 2 052007 3 012008 5 Output shoudbe: Output: 012007 2 022007 2 032007 2 042007 2 0520...

Hi

We are planning to upgrade 4.X to Datastage 7.5.2.

Could you please suggest me what are the steps I need to follow ?

is there any major Imact ?

Thanks in Advance.

Thanks and Regards
srini