 Related Questions ODBC : a) Poor Performance. b) Can be used for Variety of Databases. c) Can handle Stored Procedures. Plug-In: a) Good Performance. b) Database specific.(Only one database) c) Cannot handle Stored Procedures. Latest Answer : Partition the table if there is huge data. This will enhance performance statistics. ... Used for Look-ups. It is like a reference table. It is also used in-place of ODBC, OCI tables for better performance. Latest Answer : We can also use the Hash File stage to avoid / remove dupilcate rowsby specifying the hash key on a particular fileld ... What are other Performance tunings you have done in your last project to increase the performance of What are other Performance tunings you have done in your last project to increase the performance of slowly running jobs? Staged the data coming from ODBC/OCI/DB2UDB stages or any database on the server using Hash/Sequential files for optimum performance also for data recovery in case job aborts.Tuned the OCI stage for 'Array Most of the times the data was sent to us in the form of flat files. The data is dumped and sent to us. In some cases were we need to connect to DB2 for look-ups as an instance then we used ODBC drivers Latest Answer : hi,i am learnining datastage server job, but i dont have project to analyze, if u have any projects plz send it gyvedamurthy@yahoo.co.in vedamurthy ... Scenario based Question ........... Suppose that 4 job control by the sequencer like (job 1, job 2, job 3, job 4 )if job 1 have 10,000 row ,after run the job only 5000 data has been loaded in target table remaining are not loaded and your job going to be aborted then.. How can short out the problem. Suppose job sequencer synchronies or control 4 job but job 1 have problem, in this condition should go director and check it what type of problem showing either data type problem, warning massage, job View Question | Asked by : Mukesh Kumar Madhav Does Enterprise Edition only add the parallel processing for better performance?Are any stages/transformations available in the enterprise edition only? Read Answers (2) | Asked by : stanis 1.What about System variables? 2.How can we create Containers? 3.How can we improve the performance of DataStage? 4.what are the Job parameters? 5.what is the difference between routine and transform and function? 6.What are all the third party tools used in DataStage? 7.How can we implement Lookup in DataStage Server jobs? 8.How can we implement Slowly Changing Dimensions in DataStage?. 9.How can we join one Oracle source and Sequential file?. 10.What is iconv and oconv functions? 11.Difference Latest Answer : DataSet supports parallelism but sequential file doesn't ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 
0