Data Stage Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Data Stage Interview Questions

Questions Answers Views Company eMail

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

Cap Gemini, TCS,

3248

what is the exact difference between dataset and fileset in datastage?

TCS,

5 45834

i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?

ABC,

1 6475

i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like this target1 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformer

2 7528

Anyone has Datastage certification free dumps for 000-418 , 000-421 codes, mail me @ manik.dwh@gmail.com 000-418 : InfoSphere DataStage v8.0 000-421 : InfoSphere DataStage v8.5

IBM,

2 11161

how to sort two columns in single job in datastage.

TCS,

1 11072

how to sort two columns in single job in datastage.

TCS,

2897

how to sort two columns in single job in datastage.

TCS,

1 7935

Which warehouse using in your datawarehouse

IBM,

2182

Hi frnds, my scenario is like i'm having a record 1234"1323£3434%343434^23232!1212$23232 in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance

IBM,

2 17009

my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?

TCS,

3 9489

source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.

2 7439

souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2

9 12270

How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?

3 9414

guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.

TCS,

2 7784

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is the use of hoursfromtime() function in transformer stage in datastage?

1061

What is data partitioning?

1197

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

3165

How a source file is populated?

1061

What is datastage?

1079

What can we do with datastage director?

1232

On which interface you will be working as a developer?

1042

What is the different type of jobs in datastage?

966

how do u catch bad rows from OCI stage? And what CLI stands for?

2795

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

2858

What is the difference between server job and parallel jobs?

1151

what is ds administrator used for?

1164

What steps should be taken to improve Datastage jobs?

1065

Is possible to create skid in dim,fact tables?

2634

Define data aggregation?

1093

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