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 15535

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

2 4696

Unix command to view the data in a dataset

IBM,

2 6726

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 6699

DataStage Scenario based Interview Questions

1 17015

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

CTS,

1 2761

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,

1561

What is use Array size in datastage

1825

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 3662

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

SLK Software,

1 3489

what is repositery?

IBM,

1928

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?

1554

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

1581

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 2671

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

Virtusa,

1795

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

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

1208

What is the difference between datastage and datastage tx?

1114

What is orabulk stage?

1103

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2115

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

4098

What is usage analysis in datastage?

1361

What are routines in datastage?

1380

Describe stream connector?

1360

What are some prerequisites for datastage?

1169

What could be a data source system?

1098

What is the purpose of interprocessor stage in server jobs?

2294

root tree will find which is server job and which is parallel job?

2039

What is quality stage?

1044

What are the functionalities of link partitioner and link collector?

1061

Lookup constraints

1306

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