Data Stage Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Data Stage Interview Questions

Questions Answers Views Company eMail

What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.

2 15423

How to move data set from one server to other?what are the steps to follow to do this?

2 4596

Unix command to view the data in a dataset

IBM,

2 6632

Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers

IBM, PR3 Systems,

4 6574

DataStage Scenario based Interview Questions

1 16920

Thanks to all people who are posting their comments...

CTS,

1 2685

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

Alpharithm Technologies,

1504

What is use Array size in datastage

1779

Hi, Please tell me how to solve this scenario in datastage ? Here we have 3 columns in a table TEST CODE,ENTRY DATE and BATCH The table looks like CODE ENTRYDATE BATCH 100 100716 1 100 100716 1 100 100716 1 200 122517 2 200 122517 2 302 555555 8 302 555555 8 302 555555 8 We need to create a seqno on grouping these 3 columns. The result should be like this. CODE ENTRYDATE BATCH SEQNO 100 100716 1 1 100 100716 1 2 100 100716 1 3 200 122517 2 1 200 122517 2 2 302 555555 8 1 302 555555 8 2 302 555555 8 3

Alpharithm Technologies,

1 3540

If the job aborted in a sequencer, how can we start that from the previews successful job.

SLK Software,

1 3425

what is repositery?

IBM,

1843

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1500

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1538

there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why

Virtusa,

1 2600

how to run a sequential file stage in parallel if the stage is used on the TARGET side

Virtusa,

1746

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Difference between in process and inter process?

1234

What is a merge?

1169

What is the difference between validated and compiled in the datastage?

1291

What is the difference between the local container and shared container?

1101

What is the difference between passive stage and active stage?

1538

Name the different sorting methods in datastage.

1049

How do you schedule or monitoring the job?

1210

What are the processing stages?

1099

What are the repository tables in datastage?

1306

how to write server Routine coding?

2123

What is the difference between hashfile and sequential file?

1259

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2228

What are the enhancements made in datastage 7.5 compare with 7.0?

1148

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

1088

How to read multiple files using a single datastage job if files have the same metadata?

1252

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