-
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...
-
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?
-
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?
-
Datastage versions difference
What is the difference between datastage 7.1 & 8.0.1 versions ?
-
How to identify updated records in datastage.
How can we identify updated records in datastage? Only updated records without having any row-id and date column available.
-
DATA Set Removed why
Why we are using orchadmin to remove dataset. why we are not using rm commond in remove dataset..and why you need dataset remove waht is the reason?
-
What are Routines and where/how are they written and have you written any routines before?
Routines are stored in the Routines branch of the DataStage Repository, where you can create, view or edit. The following are different types of routines: 1) Transform functions 2) Before-after job subroutines 3) Job Control routines
-
Where do you use Link-Partitioner and Link-Collector ?
Link Partitioner - Used for partitioning the data.Link Collector - Used for collecting the partitioned data.
-
-
Job based scenario
TABLE T1 with c1 and Table T2 with c1
1 3
2 4
2 5
3
4
5
... -
-
No of processors in DataStage
How do we know the no of processors in a job? Is there any specific calculation for this.
-
-
Sequence Job Creation Scenario
You are given 2 jobs say job A and Job B with parameters x and y respectively. You need to create a sequence job. If you pass parameter x then Job A should run, If you pass parameter y then Job B should run, if you dont pass any parameter then Both Job A & B should run
-
How we can implement Bulk Collect methodology in Datastage
I have faced an interview question recently.
In database we are using Bulk Collect concept to load the bunch of records ata time.
How we will achieve the same process in Datastage ?
Can we use any paticular stage or any other methodology we can implement.
Can any one help me on this.
Thanks in advance.
Aloka -
Store Rejected Record
In join stage how we will store the rejected record in one file?
DataStage Interview Questions
Ans