Why array list is used in Oracle OCI stage? Brief about Important Options in OCI Stage.
If are given a list of .txt files and asked to read only the first 3 files using seq file stage. How will you do it?
What is the use of sort stage when you have explicit sort stage?
What is meant by real-time integration in terms of datastage and how is different from the same in Informatica.Explain batch and real time processing capabilities of both ETL tools with their characteristic
How will you rename all of the jobs to support your new File-naming conventions?
Explain how data dependency is studied using Metadata of Datastage?
What are the main features of DataStage 8.01 Version?
Latest Answer: There are several new futures includes in DS 8.0.1 compare to 7.5 version.In 8.0.1 IBM included Quality stage, IBM information server (profile stage and audit stage) . these are not
available in 7.5 version.Quality Stage: is helps you to check the data ...
How to Delete Dataset in Datastage Parallel Jobs?
Latest Answer: Deletingg dataset can be done in two ways:1. Orchasmin utility in Unix2. Dataset management toolTo use Orchadmin in unix, one has to set environment for DataStage by setting following environment variables:1. PATH 2. LIBPATH3. DSHOME4. ...
A sequential file has 8 records with one column, below are the values in the column separated by space,1 1 2 2 3 4 5 6In a parallel job after reading the sequential file 2 more sequential files should
Latest Answer: 1) We have an stage called Remove duplicate stage through which we can delete the duplicate records.2) Use the aggregator stage and specify the particular column on which you want to delete the duplicates ...
With a Lookup stage the input stage has 1million records and reference link has 1million records. What is the best Partition method and why?
Latest Answer: Better to use JOIN or MERGE stage in place of Lookup. If input data is low in compare to reference data then Lookup is recommendable. Assumption is 1:100 or more. ...
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
