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

Topic :: Data

Data Interview Questions

Questions Answers Views Company eMail

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

TCS,

2043

write a query filter the null value data following source? name age john 30 smith null null 24 sharp 35 i want output name age john 30 sharp 35

TCS,

1 5386

write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24

HP,

2 6157

In datastage can ve find the job based on source table name ??

TCS,

1 9475

Why data link layer is divided into two layers?

HCL,

2 14139

in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify

Patni,

3 7446

write knight tour problem which is present in datastructure

2670

How informatica process data means how informatica works?

TCS,

2 13179

Can you calculate the mean, median and mode of the following data set using data step logic? Don't use any function or procedure. data a; input age @@; datalines; 22 32 32 32 43 23 24 56 45 54 28 29 27 26 25 28 30 20 18 37 36 47 46 56 19 20 ; run; I have calculated the mean which i have posted in the answer section.

HSBC,

6 18618

What is the internal processes of integration server in Informatica? How data will be extract and load to the target?

TCS,

2874

how to configure databases through datastage

2 12375

Difference between ADO.net Dataset , ADO Record Set & ADO Data Reader?

HCL, NIIT,

3 10270

which of the below functions is used to search data withing a range based on a condition?

eClerx,

1 9034

For a combobox and a listbox same datatable given as a datasource. Now problem is that whenever focus of listbox changes selected value of combobox also get change or vice versa. what to be done to avoid this. According to requirement we cannot make different datasouce.

Syntel,

2 5991

We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year wise list partition). How do i simulate the same in teradata.

IBM,

2 7076