Can you connect to the Oracle database from SQL*Plus on your windows server machine? Yes.. Is there any configurations to connect the oracle enterprise stage to processs the records... In this ODBC stage is working fine but not working the oralce and DB2 plz give me how to process for that.is there...
thanks for reply.... but my requirement is Don't use any of the part ions technic and sort ...unique I need duplication records in one file and remaining records in another file .using only for transformer stage..don't use any remove duplicate .in transformer don't use any of the partion technic ......
I have the problem regarding oracle enterprise stage.it will not connected in datastage 8.0.1 is there any patches to install on our system are any configurations are there plz give me the information for how to connect on out windows system..
Our requirement is DB-->TR-->Seq or DB(rest of the records in target) | Rejected file(seq)(in this i need duplicates in rejected file rest of the records in target) plz give me the briefly explanation.if it is posible with screen shots to send me.. my mail-id:hemanthrao.k@gmail.com Thanks in advance...
How can I separate the duplicate and rest of the rows in other file. This is only using of transformer stage don't use any partitions and sort or remove duplicate stage..