Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

IBM Data Stage Interview Questions
Questions Answers Views Company eMail

Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.

6 7364

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)

1428

in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.

1 4090

I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2 2 Output3: 3 i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help

8 7937

Hi guys, Design job sequence, we have 3 sources, in that 1st source in abort then only run the remaining sources.. How please design the job. Thanks.

2 4737





Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.

1 4103

Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks

3 5921

Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks

2 6539

what is diff b/w datastage 8.1,8.5,8.7?

1 7881

What is difference between 8.1 , 8.5 and 9.1 ?

1 13693

Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??

1 6869

how to call sequential generator in datastage?

1 2852

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

2215

which is the most complex job in your career? Please tell me answer?

2 5205

how many types of sorting the data in data stage?

1 5067

Post New IBM Data Stage Interview Questions




IBM Data Stage Interview Questions


Un-Answered Questions

What is the apache?

115


Explain about analysis services?

138


Explain how do the availability of water and light and the climate affect the growth of a population?

9


What is 'funding volatility ratio'?

140


Define application object in asp?

75






What is the type of the following Array?, val arr = arrayOf(1, 2, 3);

30


How can we transform row to column?

115


What are the different boolean operators in JavaScript?

145


Explain kararch effect?

124


Is dos operating system still in use?

16


What is array class in java?

125


What is filters in web api?

75


what is static frequency converter?what is the function...of sfc...?

1267


Explain what is general insurance policy? What does it cover? : insurance sales

75


What is Mapper in Hadoop MapReduce?

92