Data Stage Interview Questions
Questions Answers Views Company eMail

How to reverse the string using SQL?

CTS,

879

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

CTS,

957

To see hidden files in LINIX?

CTS,

929

sed,awk,head

CTS,

954

How to read the length of word in unix?

CTS,

869

options available in sequence job to run,validate?

CTS,

820

What is the difference between validate and compile?

CTS,

1 3153

How to convert alpha Numeric values to alpha using functions?

CTS,

1 2074

what is the use of materialized view?

CTS,

941

table actions available in oracle connector?

CTS,

1078

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,

1111

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

Cognizant,

1068

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

Cap Gemini,

1 2107

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 1860

What steps should be taken to improve Datastage jobs?

625


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2527


What is the use of datastage designer?

627


What are the differences between datastage and informatica?

560


What is apt_config in datastage?

689


How to clean the datastage repository?

686






How to implement complex jobs in data stage?

602


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

968


What is the difference between orabulk and bcp stages?

562


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

1111


Enlist various types of routines in datastage.

632


How many Key we can define in remove duplicate stage?

811


What is the purpose of interprocessor stage in server jobs?

1713


Have you used Unstructured data?

820


What are stage variables, derivations and constants?

654


CHANGE CAPTURE

875