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,

1526

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 2907

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 }

Lookup constraints

1254

Which commands are used to import and export the datastage jobs?

1412

What is the roundrobin collector?

1097

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3754

describe the Steps to confiure a Qlogic switch

2383

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2261

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

1008

What is the flow of loading data into fact & dimensional tables?

1062

How to read the length of word in unix?

1380

Can you explain players in datastage?

1197

What is the command line function to import and export the ds jobs?

1153

What is the difference between datastage and datastage tx?

1065

How to RD using transformer?

1424

Highlight the main features of datastage?

1160

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2293

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