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

Topic :: Data

Data Interview Questions

Questions Answers Views Company eMail

How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?

1947

You need to perform an analysis on a massive dataset by groups, but are unable to sort the data due to memory constraint. How would you accomplish the task?

2 5559

Please write codes to merge two datasets and keep every record in the first dataset.

1 4797

When merging 2 datasets with a common variable (not merge key), how to keep both?

3 7036

Write SAS codes to compare two datasets. Suppose the allowable difference is 0.1.

2 7254

is built-in data-type are abstract data-types in java

1853

in qtp 3 sheets is there in data table like global, action1, action2. I want to check the rows and columns in action2. how can check using script?

Polaris,

2 7198

can we load the data with out a primary key of a table? what is target plan?

IBM,

6 15230

how to load the data to fact table?

2719

how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.

1 4395

what is the difference between server and database?

Infotech,

2 5717

what is executable in DataStage?

2 11077

what is the difference between data table and spread sheet?

1 5649

Pls tell me what is troubleshooting in datastage view?

1 8181

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1884