DSXchange

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...

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...

Is it possible to call a stored procedure from odbc stage and capture its return value in datastage?

Please help

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...

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=

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...

Any idea's anyone...Please

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...

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...

It's going to grow in big size...

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 ...

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...

Please post the warnings from the director.

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...

yes it is...

no matter one or 100 you can use modify stage. You don't need a transformer for such tasks.