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,

1592

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

CTS,

1556

To see hidden files in LINIX?

CTS,

1586

sed,awk,head

CTS,

1500

How to read the length of word in unix?

CTS,

1433

options available in sequence job to run,validate?

CTS,

1363

What is the difference between validate and compile?

CTS,

1 4364

How to convert alpha Numeric values to alpha using functions?

CTS,

1 3182

what is the use of materialized view?

CTS,

1635

table actions available in oracle connector?

CTS,

1654

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,

1600

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

Cognizant,

1604

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

Cap Gemini,

1 2986

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 2710

What steps should be taken to improve Datastage jobs?

1120

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is active and passive stage?

1466

How do you import and export the datastage jobs?

1209

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

855

Why fact table is in normal form?

1307

Which warehouse using in your datawarehouse

2233

explain about citrix scheduling tool in datastage

2509

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2247

What is a folder? Difference types of stages?

1240

What is a quality stage in datastage tool?

1127

How do you run datastage job from the command line?

1129

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

820

what is 'reconsideration error' and how can i respond to this error and how to debug this

2673

Differentiate between Join, Merge and Lookup stage?

1141

What are sequencers?

1172

Demonstrate experience in maintaining quality process standards?

2635

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