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

Topic :: Data

Data Interview Questions

Questions Answers Views Company eMail

calculate the sum of value using only DATA STEP. data count_; input year name $ value; cards; 2006 xxx 10 2007 yyy 12 2006 xxx 20 2008 yyy 15 2007 xxx 15 ; out put should be like this year name T_value ----------------------- 2006 xxx 30 2007 xxx 15 2007 yyy 12 2008 xxx 15

6 8504

Query regarding SBI biodata form : Q1 : What to fill in centre , the whole address of the interview place or just city Q2 : Identity certificate is needed for how many years

Banking, State Bank Of India SBI,

1 23956

DataStage 7.5 & DataStage 8.5 :Which Oracle Database version is supported as target datasource?

3445

Can U write a C-program to print the size of a data type without using the sizeof() operator? Explain how it works inside ?

HCL, TCS,

3 6229

After transferring of data from flat file to application server i found that it is showing wrong data .Say i had currency in flat file as 1000.00 USD. After transferring i found it is showing as 100.000 in the application server. How will you handle this case?

Thomson Reuters,

1 6642

is database gud carrier option??

1 3615

Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD

Wipro,

6 12050

What will transport layer do when data coming from session layer. They asked about intial operation(3 - way handshake)

HCL,

1 4307

How to copy one PS file to multiple PS files with same data?

1 15402

how to retrieve the top 2 salaried persons from a database?

Orion Laboratories,

7 9966

write a sql query retrive all xml data. how to retrive xml data wit single sql query.

TCS,

2395

how to retrive xml data for using sql query?

IBM, TCS,

3 7041

Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.

2 13882

Hi any one has datasatge 8.5 certication dump could you please provide your details i will contact you. send reply to my mail rajaadivi@gmail.com Thanks in Advance

2 4020

which utitility can use for loading the data from non-teradata to teradata ?

Wipro,

5 13450