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,

3211

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

TCS,

5 45505

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 6380

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 7419

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 11037

how to sort two columns in single job in datastage.

TCS,

1 10961

how to sort two columns in single job in datastage.

TCS,

2842

how to sort two columns in single job in datastage.

TCS,

1 7869

Which warehouse using in your datawarehouse

IBM,

2115

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 16882

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 9337

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

2 7334

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 11955

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

3 9270

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

TCS,

2 7683

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is job control?

1034

How to convert RGB Value to Hexadecimal values in datastage?

3927

How the ipc stage work?

1078

Differentiate between datastage and informatica?

1140

What are the different types of lookups in datastage?

1006

what is 'reconsideration error' and how can i respond to this error and how to debug this

2555

How many Key we can define in remove duplicate stage?

1310

How many types of views are there in a datastage director?

1231

How do you register plug-ins?

920

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

752

What are iconv and oconv?

1181

What are the types of hashed files in data stage

1058

How do you reject records in a transformer?

1060

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2403

What are the differences between datastage and informatica?

1111

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