Search found 17 matches
- Wed Dec 29, 2004 9:40 pm
- Forum: IBM QualityStage
- Topic: Different Stages in QualityStage
- Replies: 2
- Views: 2834
- Wed Dec 29, 2004 12:49 am
- Forum: IBM QualityStage
- Topic: Different Stages in QualityStage
- Replies: 2
- Views: 2834
Different Stages in QualityStage
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
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
- Wed Dec 22, 2004 3:00 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Difference between Insert else Update and Update else insert
- Replies: 4
- Views: 5720
- Wed Dec 22, 2004 2:31 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Difference between Insert else Update and Update else insert
- Replies: 4
- Views: 5720
Difference between Insert else Update and Update else insert
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
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
- Tue Oct 05, 2004 9:51 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Installation error
- Replies: 6
- Views: 3024
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...
- Tue Oct 05, 2004 4:16 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Installation error
- Replies: 6
- Views: 3024
- Wed Sep 15, 2004 12:46 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: OCI truncated Date
- Replies: 11
- Views: 4352
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 ...
- Tue Sep 14, 2004 10:27 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: OCI truncated Date
- Replies: 11
- Views: 4352
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 ...
- Tue Sep 14, 2004 6:06 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: OCI truncated Date
- Replies: 11
- Views: 4352
OCI truncated Date
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...
- Tue Aug 10, 2004 10:48 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Installation error
- Replies: 6
- Views: 3024
- Tue Aug 10, 2004 6:38 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Installation error
- Replies: 6
- Views: 3024
Installation error
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...
- Thu Jul 29, 2004 11:54 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Table duplication
- Replies: 2
- Views: 2231
Table duplication
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...
- Thu Jul 29, 2004 11:46 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Executing Parallel Jobs
- Replies: 3
- Views: 1980
Executing Parallel Jobs
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...
- Mon Jul 19, 2004 4:36 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Two input lookup parameters within a query and subquery
- Replies: 1
- Views: 1323
Two input lookup parameters within a query and subquery
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...
- Tue May 18, 2004 7:20 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Out parameters in DataStage
- Replies: 2
- Views: 1606
Out parameters in DataStage
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...