Data Stage Interview Preparation Guide
Sharpen your Data Stage interview expertise with our handpicked 11 questions. These questions are specifically selected to challenge and enhance your knowledge in Data Stage. Perfect for all proficiency levels, they are key to your interview success. Download the free PDF now to get all 11 questions and ensure youre well-prepared for your Data Stage interview. This resource is perfect for in-depth preparation and boosting your confidence.11 Data Stage Questions and Answers:
1 :: Is there any possibility to generate alphanumeric surrogate key?
It is not possible to generate alphanumeric surrogate key
in datastage.
in datastage.
2 :: How to enter a log in auditing table whenever a job get finished?
some companies using shell script to load logs into audit table or some companies load logs into audit table using datastage jobs.these jobs are we developed.
3 :: What is audit table?
audit table is nothing but when the job is developed,how many no of stages are used,each stage having how many no of input records are there also how many no of out put records are there,job start date,job end date etc these information having audit table
4 :: How to add zero "0" before record in a field?
String("o",1):Column name
Here 1 is how many zeros we want
Here 1 is how many zeros we want
5 :: How to get the unique records on multiple columns by using sequential file stage only?
in sequential file there is one option is there i.e
filter.in this filter we use unix commands like what ever we
want.in this question we use uniq command in filter.
filter.in this filter we use unix commands like what ever we
want.in this question we use uniq command in filter.
6 :: If a column contains data like
abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc,roy,pwe,aaa,xxx,xyz,roy,xok....
how to send the unique data to one source and remaining data to another source?
by using create key change column is true is disp;ays
duplicates records
if it is false it displays non duplicate records
first keep all the records in sort order
duplicates records
if it is false it displays non duplicate records
first keep all the records in sort order
7 :: If a column contains data like
ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?
seq file ------> Transformer -------> target
1.extract the source data into seq file.
2.In transformer source column to target , and apply the field function
Field(column name, ',' , 1)
next same drag the source column to target , and apply the field function
Field(column name,',',2)
.
.
.
Field(column name,',',5)
1.extract the source data into seq file.
2.In transformer source column to target , and apply the field function
Field(column name, ',' , 1)
next same drag the source column to target , and apply the field function
Field(column name,',',2)
.
.
.
Field(column name,',',5)
8 :: How to design file watch jobs?
Using Control-M Tool.
9 :: How to remove blank spaces from data?
By using the following command you can remove blank lines from unix file:
$ sed 's/ *//g' sample
$ sed 's/ *//g' sample
10 :: What is Cleanup Resources and when do you use it?
When we want to kill the process in unix we need clean up resources.
Actually to kill any process we need process id. Then this option is available in administrator then we have to check the option called clean up resouces
Actually to kill any process we need process id. Then this option is available in administrator then we have to check the option called clean up resouces