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,

1519

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

CTS,

1498

To see hidden files in LINIX?

CTS,

1520

sed,awk,head

CTS,

1459

How to read the length of word in unix?

CTS,

1376

options available in sequence job to run,validate?

CTS,

1312

What is the difference between validate and compile?

CTS,

1 4244

How to convert alpha Numeric values to alpha using functions?

CTS,

1 3092

what is the use of materialized view?

CTS,

1561

table actions available in oracle connector?

CTS,

1605

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,

1542

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

Cognizant,

1549

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

Cap Gemini,

1 2900

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 2641

What steps should be taken to improve Datastage jobs?

1062

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What are orabulk and bcp stages?

1119

Differentiate between datastage and datastage tx?

1046

If you want to use the same piece of code in different jobs, how will you achieve it?

1150

Define APT_CONFIG in Datastage?

1068

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3245

How can you write parallel routines in datastage PX?

1011

What is datastage engine?

1171

What are the different layers in the information server architecture?

1122

Differentiate between datastage and informatica?

1179

What is the use of datastage director?

1013

Describe the main features of datastage?

1072

What is the method of removing duplicates, without the remove duplicate stage?

1017

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

930

How you Implemented SCD Type 1 & Type 2 in your project?

4125

What is use Array size in datastage

1775

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