Data Stage Interview Questions
Questions Answers Views Company eMail

how to do pergformence tuning in datastage?

TCS, Symphony, MCA,

4 30276

what is the difference between datasatge and datastage TX?

6 20071

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

IBM,

7 10138




How can we run same job in 1 day 2 times

IBM,

4 9073

Wat is pre-load in Hashed file

Patni,

1 6237

How can we run same job in 1 day 2 times

IBM,

7 12473

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

DELL, IBM,

8 37361

tell me abt Datastage trigger?

IBM, HP,

1 13873




How do y read Sequential file from job control?

IBM, Telesis, HP,

2 9317

How do u call shellscript/Batch file from DS?

HP,

4 18263

What are the different database update actions available?

HP,

1 6232

Wat is isolation level and when do u use them?

IBM, HP,

1 14835

How do u view log file for a particular job?

HP,

6 16901

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

HP,

7 19605

How did you reconcile source with target?

HP,

2 6249


Post New Data Stage Questions






Un-Answered Questions { Data Stage }

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.

2431


Can you filter data in hashed file?

2212


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

1557


How to convert RGB Value to Hexadecimal values in datastage?

2367


in oracle target stage when we use load option and when we use upsert option?

885


how can we create rank using datastage?what is the meaning of rank?

6134


What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

897


How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

1098


What are the partitioning techniques available in link partitioner?

709


Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

1956


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?

862


how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

999


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

865


explain about citrix scheduling tool in datastage

888


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?

122