DSXchange

Thats looks like the best option
Thanks!!!

All I am doing is selecting all rows from a table in one Schema and inserting it into another table in a different schema "Update action being -Truncate table then insert rows"

Thanks Ken,

I will use the sqlldr
But is there any solution for the existing problem? I have seen a lot of posting on this topic but no proper solution

I am doing a simple load using two OCI Stage and a transformer in between. The number of records to be populated are around 40 million. I had left the job to run overnight. In the morning i get this error message "fixListing_Scp_Doa..Transformer_2: ORA-01555: snapshot too old: rollback segment ...

Kim,

The workaround with our present version (7.0.1) looks a little complex, so as you suggested we better go for an upgrade (Which we are planning shortly)

Thanks for all the information I really appreciate it

Hey Kim
Thanks man
This looks like a JOB!!
I am not working in the weekend, heading towards the mountain for some skiing. .Will start working on this, the first thing Monday morning. I will let you know the results.

I am trying to import EtlStats20050215.dsx downloaded from Kim's website (http://www.duke-consulting.com/DataStage_Tips_plain.htm). I get the following errors - CJobDefn - ROOT - Unknown property name 'JobSeqCodeGenOpts' BuildEtlQaSqlHash does not exist. I am getting similar errors for all the other...

Thanks Ray

The number of rows cannot be predetermined (So i wont be able to use Static Hash File). For preallocate disk space by specifying MINIMUM.MODULUS do I use the standard formula's or is there any other way we can optimize the performance?

Thanks for the info
I want to improve/reduce the time taken for writing into the hash file. What changes can i make to the Hash files option???

Hi, I am trying to run a job which creates a HASH file from a table, there arearounf 12 million recordsin the table. In the log the status shows as waiting for the job XXX to start. The status shows as running only after a period of 30 minutes. I am using the default hash file options i.e. Type 30(D...

You could do it in oracle using the Max(Decode.....) function i.e Pivoting Data . I have done something similar to this long time ago. You can try and explore on this one.

If you are sure about the sequential format, you could also take the first 8 digits and put it into a Stage Variable and then you could take the sequential counts and append it to the Staged Variable taken onto each column. You will get the results in different columns. Ex. Staged Variable - BranchN...

Thank you all,
I got the solution from Craig Hulett
The problem was a little wierd - The job was not accepting "Column-generated SQL Query" but the same query when taken as a "User defined SQL query" worked fine

No it is not a new Installation. I have 40 such similar jobs, but i am facing problem with this one. What i assumed was that this was due to some network problem or abrupt power shut down (or is there any limitations on the number of unique keys? as this table has 13 of them) I am now not able to cr...

Hi, I am getting this error message when i try to view data from a Oracle 9i OCI Plug-in stage "Error Calling SubRoutine DSD.Browse (Action =3)" Check Datastage is set up correctly in project EIW. Then the connection gets broken!!! "The connection is broken(81002) Any idea whats this....