Search found 237 matches
- Sun Jul 14, 2013 8:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Transaction Processing
- Replies: 1
- Views: 2136
Transaction Processing
Hello... I would to get some assistance and guidance regarding a scenario I would like to handle. I have some ideas in my mind but looking for the best practice. One of the requirement is, the ETL load should not corrupt the tables with half loaded data anytime. Either the load has to be completed s...
- Sat Jun 01, 2013 12:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Poor performance - Extracting Oracle Table
- Replies: 9
- Views: 6196
Hey... You might need to think a bit differntly in this case. As you are looking for a one time load, you might need to go for a full dump in some sort of file structure from the DBA. DBA has privilage to get the direct dump from the database and take a cut off date for the dump. Zip the file and dr...
- Thu Jul 07, 2011 12:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Capture Stored procedure Retrun value
- Replies: 2
- Views: 2921
Re: Capture Stored procedure Retrun value
Is it possible to call a stored procedure from odbc stage and capture its return value in datastage?
Please help
Please help
- Mon Jul 04, 2011 4:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Capture Stored procedure Retrun value
- Replies: 2
- Views: 2921
Capture Stored procedure Retrun value
I have a requirement to call a stored procedure from ODBC stage and capture the return value. The issue is , I don't know what should be the name of the return value, I tried all possible things but it gives me the binding error. "##W TFOR 000000 05:00:06(014) <ODBC_Enterprise_20> When checking...
- Sat Jun 11, 2011 10:57 am
- Forum: General
- Topic: Job Parameter removing quotes
- Replies: 2
- Views: 3517
Yes, I searched and got my solution. Thanks Chullet.
For the interest of anyone who search for this the solution is here.
viewtopic.php?t=128561&highlight=
For the interest of anyone who search for this the solution is here.
viewtopic.php?t=128561&highlight=
- Sat Jun 11, 2011 7:11 am
- Forum: General
- Topic: Job Parameter removing quotes
- Replies: 2
- Views: 3517
Job Parameter removing quotes
Hi... I have a simple job like the following. ODBC Stage ---------> Transformer ---------> Dataset. In odbc, I am using a sql with an "IN" statement where in I want to give comma separted values. This comma separated values I want to give as a job parameter. select X,Y,Z from TABA where st...
- Mon Apr 04, 2011 10:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CDC - Design approach
- Replies: 4
- Views: 3642
- Mon Mar 28, 2011 4:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Design Advise - Large number of servers
- Replies: 3
- Views: 2770
What other option I have other than odbc, if my database is SQL server? I am using 7.5.X . yes it's remote and each server have a database. The name of db is dame and tables also same in each server, jsut that it's physically separated. Each physical location they are maintaing a local sever. The ta...
- Mon Mar 28, 2011 2:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Design Advise - Large number of servers
- Replies: 3
- Views: 2770
Design Advise - Large number of servers
I have a requirement to connect to 2000 servers and extract the data. The point is, each server is hosting same type of database and metadata also same. I am just wondering creating 2000 separate dsn to connect to all the servers and extract the data is not a usual thing in ETL space. The data I nee...
- Thu Mar 17, 2011 7:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CDC - Design approach
- Replies: 4
- Views: 3642
- Thu Mar 17, 2011 1:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CDC - Design approach
- Replies: 4
- Views: 3642
CDC - Design approach
I am looking for a design help, to understand the best way to do a CDC. Please help. I have 4 tables in oracle that grows in millions of size. That has key columns but no timestamp / Date / Batch Id. The tables are not indexed as well. My table can have insert/update records. What I need is, i need ...
- Mon Feb 21, 2011 10:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to convert the Varchar(9) to Numeric(9)
- Replies: 7
- Views: 4493
They've already posted the issue and the fact that it was resolved, so unsure why you are bringing scale into the picture, it doesn't really seem relevant here. hmm.. Actully while I was replying and posting the reply the issue got solved...:) well.. I faced a similar issue and all 000000 was becau...
- Mon Feb 21, 2011 6:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: sql code 1480 error while trying to do insert
- Replies: 2
- Views: 2749
Re: sql code 1480 error while trying to do insert
Please post the warnings from the director.
- Mon Feb 21, 2011 6:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to convert the Varchar(9) to Numeric(9)
- Replies: 7
- Views: 4493
Alrt ...so here is the issue... e.g. you are having a varchar '777777777' and you are converting and copying to decimal 9 using stringTodecimal and might have declared the legnth of your decimal field as 9 and scale 2. now the string function will convert your function to 777777777.00 so see the tot...
- Mon Feb 21, 2011 6:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: To Convert Datatype of one column.
- Replies: 4
- Views: 2293