-
Memory allocation while using lookup stage
Hi friends, i know while using lookup stage if the lookup table has huge amount of data we will go for sparse lookup or else will use normal lookup. would anybody explain how the memory will be allocated for both type of lookups?
-
-
Delete Dataset
How to Delete Dataset in Datastage Parallel Jobs?
-
Datastage versions difference
What is the difference between datastage 7.1 & 8.0.1 versions ?
-
Datastage Lookup
By using lookup we join the data from more than one table, we can implement the same using join stage, then what is the need of Lookup stage especially in Datastage?
-
Flatfiles Validations
When we are extracting the flatfiles, What are the basic required validations?
-
-
Reading multiple files through sequential file
What are the ways to read multiiple files from sequentila file if the both files are differnt
-
-
-
What are OConv () and Iconv () functions and where are they used?
IConv() - Converts a string to an internal storage formatOConv() - Converts an expression to an output format.
-
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 Size' and 'Rows per Transaction' numerical values for faster inserts, updates and selects.Tuned the 'Project Tunables' in Administrator for better performance.Used sorted data for Aggregator.Sorted...
-
How did u connect with DB2 in your last project?
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 to connect to DB2 (or) DB2-UDB depending the situation and availability. Certainly DB2-UDB is better in terms of performance as you know the native drivers are always better than ODBC drivers. 'iSeries...
-
User Created Stages
Explain Wrapped, Build and Custom stages?
-
Join and Lookup Stage
If you have a huge volume of data to be referenced, which stage will you use? Join or Lookup stage? Why
-
-
Dimension Modelling types along with their significance
Data Modelling is Broadly classified into 2 types. a) E-R Diagrams (Entity - Relatioships). b) Dimensional Modelling.
-
No of processors in DataStage
How do we know the no of processors in a job? Is there any specific calculation for this.
-
-
What is the purpose of the copy stage:
What is the uses of the copy stage with out copies input link to output link datasetsand it can have any purposes pls send me with example
DataStage Interview Questions
Ans