DSXchange

Thanks a lot, Ray

Hi All

I am interested in knowing the different stages within QualityStage along with its brief functionality.

Can anyone please help me on this ??


Thanks
Anand K

Thanks for the quick response, Sridhar.

So what I understand is for records running into millions, we need to use the Update else Insert and for smaller amount of data we need to use Insert else Update.

Anand

Hi All

Can any one suggest on which all situations we need to use the "Insert new rows or Update existing rows" and "Update existing rows and Insert new rows" in ORAOCI8 Stage?


Thanks in Advance
Anand

Hi The server is installed in a Windows XP machine. The DS clients are also installed in 4 other Windows XP machines. I login (Windows login not DS login) to the DS server machine with login id, say, XYZ. The Windows login id for the DS clients machines are different, say, ABC, KJM, etc.. When the c...

Hi All

Can anyone please suggest some method to the above mentioned situation?

Thanks

Anand K

The SQL did NOT give an error while executed through TOAD and SQLPLUS. I am using ORACLE 8i and in that the fields are defined as NUMBER only. There is no size specified for these in ORACLE. In DataStage, when I imported the fields, it was by default 38 for these fields. And after going through the ...

Double-check everything, as those are the patented answers to this problem. What kind of problematic fields are included in your table? NUMBER? LONG? Perhaps if you listed the Oracle fields and how you have them defined in DataStage, people could help spot the problem child. I have NUMBER, VARCHAR ...

Hi All... I am posting a query that has been already discussed in this forum. But none of the answers were helpful in my case. It is the warning message given within DataStage "OCI has truncated data".. I found and tried all the answers - trimming the fields, making the number 30 to 40 etc...

Thanks Amos.. But again I would like to know how to set different levels of user id and password as this is first time i have installed the server and in Windows machine.

Hi All.. I have installed DataStage server in a Windows machine. DataStage Clients are installed in some of the other machines working in Windows XP.. If for a single given Windows Login id, the Client is able to connect to the Server. But if logged in using a different login the it is showing the f...

Hi All I have to create/replicate some tables from one schema to another. There are no stages between the Source Oracle stage and the Target Oracle stage If there are 10 tables I am creating 10 different jobs for the same. Please let me know if there is a work around for the same like parameter subs...

Hi All I am facing a problem running the parallel jobs I have installed DataStage client and Server in the same PC which runs on Windowd XP. I was able to create the jobs and compile it successfully.. But when I try executing the same it is giving me the following error.. "This jobtype is not c...

Hi All I wanted to use following query as User defined query in Oracle Source Stage with two input lookup parameters. I would like to know, Can I pass two values from other source stage (CASE_KEY and TR_CD in the following example) SELECT DISTINCT FDRT_KEY FROM FD_RATES WHERE BNTP_KEY = ( SELECT DIS...

Hi All.. I have a procedure which has 2 in parameters and 4 out parameters. These 4 out parameters are neither inserted in a table nor captured in a file. Please suggest me a method by which the 4 out parameters in the stored procedure (source) can be captured in a table or file. It will be of great...