Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Data Stage Interview Questions
Questions Answers Views Company eMail

What is the importance of the exception activity in datastage?

241

What is the difference between informatica and datastage?

251

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

250

Describe the architecture of datastage?

236

Describe link sort?

252

What is ibm datastage flow designer?

278

What are operators in datastage?

273

What is a ds designer?

228

How do you run datastage job from the command line?

233

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

248

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

220

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

114

1. How many People are part of your Team? 2. Explain how you create jobs or flow of project? 3. Join Stage vs Lookup vs Merge Stage 4. Summation scenario based question - How you find sum of salary for a specific employee (Explain stages and flow of job)? 5. Explain Remove duplicates stage ? Can you do sort in this stage? 6. SQL Questions - Joins - Types, Difference between Join and Union 7. Unix Questions - How you run the Job, How you list all jobs in project 8. Explain Environmental Variables? 9. SQL Scenario - If you have 3 Identical record in a Table, Ex: 1, Ram, Xyz; 1, Ram, Xyz; 1, Ram, Xyz; Delete only 2 of the records and keep only 1 using the Delete query. How you will you do this?

1 168

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

81


Post New Data Stage Questions






Un-Answered Questions { Data Stage }

Define ds designer?

253


What are sequencers?

255


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

1816


Difference between in process and inter process?

263


What are the types of containers and how to create them?

235






Define Job control?

286


i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

1819


Which warehouse using in your datawarehouse

1340


How many areas for files does datastage have?

267


Describe link sort?

252


Could anyone give brief explanation bout datastage admin

1608


Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

1361


how to export or import the jobs in .ISX file

249


Explain usage analysis in datastage?

264


What are the different layers in the information server architecture?

259