Hello,
I'm trying to read 10 records from a sequential file and write to an oracle table using an ODBC stage since OCI does'nt work for the time being.......
Out of the 10 records only 3 of them are unique and when i write it to the table it writes only the unique records.........but i wanted it to write all the 10 records........... Does any one know what the problem is or am i missing something????
Thanks
Prince.
writing Duplicate Records using ODBC
Moderators: chulett, rschirm, roy
You may want to post something (as in another thread) on the subject of "OCI doesn't work for the time being" as using ODBC is... less than ideal.
How would you process 'duplicate' records outside of DataStage? It's no different here. Duplicates must, in some fashion, either update or replace the offending record with the same key.
What update action are you using in the stage? Have you considered using a hashed file inline in the job to track keys used so far and control the whole 'insert versus update' portion of the job?
You do realise that when you write "all 10 records" to the table that there won't be 10 records in it, yes?
How would you process 'duplicate' records outside of DataStage? It's no different here. Duplicates must, in some fashion, either update or replace the offending record with the same key.
What update action are you using in the stage? Have you considered using a hashed file inline in the job to track keys used so far and control the whole 'insert versus update' portion of the job?
You do realise that when you write "all 10 records" to the table that there won't be 10 records in it, yes?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Hi Prince,
Welcom Aboard!!!
Craigs main cocern is to let you investigate the reason behind the duplicates.
Obviously any primary key mention in a table wont accept duplicat keys.
If you are in the testing phase and want to desperately load the table with those duplicate data, try droping the primary key from the table.(Which will be totally illogic )
-kumar
Welcom Aboard!!!
Craigs main cocern is to let you investigate the reason behind the duplicates.
Obviously any primary key mention in a table wont accept duplicat keys.
If you are in the testing phase and want to desperately load the table with those duplicate data, try droping the primary key from the table.(Which will be totally illogic )
-kumar