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 15424

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 6575

DataStage Scenario based Interview Questions

1 16923

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,

1507

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 3541

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

SLK Software,

1 3426

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?

1501

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 2601

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 }

What is orabulk stage?

1047

What are stage variables, derivations and constants?

1226

Explain Quality stage?

1156

Can you explain kafka connector?

1312

How complex jobs are implemented in datstage to improve performance?

1042

What is difference between symmetric multiprocessing and massive parallel processing?

1141

Give an idea of system variables.

1036

What is the method of removing duplicates, without the remove duplicate stage?

1026

Why fact table is in normal form?

1251

Differentiate between operational datastage (ods) and data warehouse?

1178

What is process model?

1976

How and where you used hash file?

1174

1088

What are the features of datastage flow designer?

1039

How many types of stage?

1179

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