Data Stage Interview Questions
Questions Answers Views Company eMail

how to do pergformence tuning in datastage?

TCS, Symphony, MCA,

4 26793

what is the difference between datasatge and datastage TX?

6 17535

What is exact difference between Parallel Jobs and server Jobs..

IBM,

7 8073

How can we run same job in 1 day 2 times

IBM,

4 7079

Wat is pre-load in Hashed file

Patni,

1 5236

How can we run same job in 1 day 2 times

IBM,

6 10541

What is exact difference between Parallel Jobs and server Jobs..

DELL, IBM,

8 31364

tell me abt Datastage trigger?

IBM, HP,

1 11781

How do y read Sequential file from job control?

IBM, Telesis, HP,

2 7741

How do u call shellscript/Batch file from DS?

HP,

4 15686

What are the different database update actions available?

HP,

1 5232

Wat is isolation level and when do u use them?

IBM, HP,

1 12907

How do u view log file for a particular job?

HP,

6 14593

How do u set a default value to a column if the column value is NULL?

HP,

7 16861

How did you reconcile source with target?

HP,

2 4781


Post New Data Stage Questions


Un-Answered Questions { Data Stage }

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

587


On which Dimension Table you implemented SCD Type in your Project

569


how to write server Routine coding?

552


How do you design PX Routines ?

664


if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

716


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

2159


explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

780


what are .ctl(control files) files ? how the dataset stage have better performance by this files?

887


Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

587


what is flow of project?

386


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

350


Can we use target hash file as a lookup ?

984


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.

2195


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?

810


what are the devoleper roles in real time? plz tell i am new to datastage....

550