Data Stage Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Data Stage Interview Questions

Questions Answers Views Company eMail

How to reverse the string using SQL?

CTS,

1525

what is the difference between == and eq in UNIX shell scripting?

CTS,

1500

To see hidden files in LINIX?

CTS,

1527

sed,awk,head

CTS,

1463

How to read the length of word in unix?

CTS,

1380

options available in sequence job to run,validate?

CTS,

1316

What is the difference between validate and compile?

CTS,

1 4259

How to convert alpha Numeric values to alpha using functions?

CTS,

1 3096

what is the use of materialized view?

CTS,

1570

table actions available in oracle connector?

CTS,

1611

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

TCS,

1550

Can you implement SCD2 using join, transformer and funnel stage?

Cognizant,

1557

In a table 100 records are there after 50records job is aborted how can u insert all records in target table.

Cap Gemini,

1 2908

Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.

1 2649

What steps should be taken to improve Datastage jobs?

1073

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is use Array size in datastage

1779

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2224

How do you remove duplicate values in datastage?

1151

What is a folder? Difference types of stages?

1175

how to delete one row in target dataset

3122

describe the Steps to confiure a Qlogic switch

2383

What is size of a transaction and an array means in a datastage?

1312

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3794

How do you generate sequence number in datastage?

1093

what is use of SDR function?

5173

What are some different alternative commands associated with "dsjob"?

1169

Name the command line functions to import and export the DS jobs?

1155

Define Routines and their types?

1186

How a source file is populated?

1065

How many Key we can define in remove duplicate stage?

1383

For More Un-Answered { Data Stage } Questions Click Here