Data Stage Interview Questions
Questions Answers Views Company eMail

What are the partitioning techniques available in link partitioner?

1753

What is the purpose of interprocessor stage in server jobs?

ASD Lab,

1724

Can you filter data in hashed file?

3341

How many Nodes configuration file you used in your last project?

1 3414

Tell me the syntax of Configuration file?

1 4184

Explain the situation where you have applied SCD in your project?

1558

What are the third party tools you used in your project?

IBM,

1 2485

How do you design PX Routines ?

1 2613

What is the use of Row generator stage?

2 12017

How you Implemented SCD Type 1 & Type 2 in your project?

3695

On which Dimension Table you implemented SCD Type in your Project

1577

How you Remove the Dataset in Unix?

5 19569

What is the difference b/w Hash file and Lookup Fileset stages?

1 9925

What is the default padding character?

IBM,

3 13982

What are the partition techniques available in your last project?

1 4583


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is the difference between server job and parallel jobs?

662


Different ways a project can be moved to production ?...example ….export-import and Version control.

1931


Can you define merge?

666


What is oci?

850


WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3263






What are the components of datastage?

646


Define ds designer?

766


What is a ds designer?

640


what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

953


How many types of stage?

673


How do you schedule or monitoring the job?

663


Difference between sequential file and data set?

641


How one source columns or rows to be loaded in to two different tables?

656


1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

1624


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

788