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,

1427

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

CTS,

1422

To see hidden files in LINIX?

CTS,

1454

sed,awk,head

CTS,

1411

How to read the length of word in unix?

CTS,

1313

options available in sequence job to run,validate?

CTS,

1260

What is the difference between validate and compile?

CTS,

1 4140

How to convert alpha Numeric values to alpha using functions?

CTS,

1 3001

what is the use of materialized view?

CTS,

1489

table actions available in oracle connector?

CTS,

1557

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,

1508

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

Cognizant,

1501

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

Cap Gemini,

1 2823

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 2546

What steps should be taken to improve Datastage jobs?

1003

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

How the ipc stage work?

1080

Explain entity, attribute and relationship in datastage?

1045

On which interface you will be working as a developer?

988

How do you schedule or monitoring the job?

1135

What are the main differences you have observed between 7.x and 8.x version of datastage?

1025

Define orabulk and bcp stages?

1069

What are the types of containers in datastage?

1143

Is the value of staging variable stored temporarily or permanently?

933

Explain ibm infosphere information server and highlight its main features?

1036

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3265

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

1081

how to abort the job its matain duplicates?

2534

What are the repository tables in datastage?

1258

Explain datastage architecture?

1336

How rejected rows are managed in datastage?

1448

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