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

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

Cap Gemini, TCS,

2473

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

TCS,

5 36360

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 4766

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 5684

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 8498

how to sort two columns in single job in datastage.

TCS,

1 8745

how to sort two columns in single job in datastage.

TCS,

2153

how to sort two columns in single job in datastage.

TCS,

1 6394

Which warehouse using in your datawarehouse

IBM,

1319

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 13370

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 7049

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

2 5495

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 7885

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

3 6720

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

TCS,

2 5384


Post New Data Stage Questions






Un-Answered Questions { Data Stage }

What are the different layers in the information server architecture?

231


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

196


What are the types of jobs we have in datastage?

265


What are routines in datastage? Enlist various types of routines.

221


Where do you see different stages in the designer?

232






Can you explain how could anyone drop the index before loading the data in target in datastage?

305


Explain ibm infosphere information server and highlight its main features?

215


What are the main differences you have observed between 7.x and 8.x version of datastage?

228


On which Dimension Table you implemented SCD Type in your Project

1178


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

1236


What are the differences between datastage and informatica?

202


How and where you used hash file?

243


Nls stands for what in datastage?

281


What is use Array size in datastage

849


Which warehouse using in your datawarehouse

1319