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,

1527

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

CTS,

1500

To see hidden files in LINIX?

CTS,

1529

sed,awk,head

CTS,

1465

How to read the length of word in unix?

CTS,

1380

options available in sequence job to run,validate?

CTS,

1317

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,

1571

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 2909

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 }

How many types of views are there in a datastage director?

1283

How to find value from a column in a dataset?

2203

What is a ds designer?

1070

Is possible to create skid in dim,fact tables?

2636

What are the different options associated with dsjob command?

1439

Can we use target hash file as a lookup ?

3327

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1873

What are the different layers in the information server architecture?

1124

Give an idea of system variables.

1036

what are the errors,warnings in datastage

2699

What is the difference between hashfile and sequential file?

1260

How to perform incremental load in datastage?

1203

What all the types of jobs you developed?

1181

Nls stands for what in datastage?

1190

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

932

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