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 15268

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

2 4444

Unix command to view the data in a dataset

IBM,

2 6505

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 6415

DataStage Scenario based Interview Questions

1 16787

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

CTS,

1 2618

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,

1446

What is use Array size in datastage

1721

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 3403

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

SLK Software,

1 3330

what is repositery?

IBM,

1771

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?

1452

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

1476

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 2525

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

Virtusa,

1687

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Why do we use exception activity in Datastage?

1230

What is the difference between datastage and informatica?

1062

Is the value of staging variable stored temporarily or permanently?

933

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3736

How many types of sorting methods are available in datastage?

1020

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2003

If you want to use the same piece of code in different jobs, how will you achieve it?

1097

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

2171

What is the use of datastage director?

975

What all are the different way to run a job?

1030

What are transforms and what is the differenece between routines and transforms?

1003

What is staging variable?

1029

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2822

EXPLAIN SCD

1341

What is active and passive stage?

1361

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