ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Google
   
 
Categories >> Software >> Data Warehouse >> Data Stage
 
 


 

 
 Teradata interview questions  Teradata Interview Questions (183)
 Business Objects interview questions  Business Objects Interview Questions (751)
 Cognos interview questions  Cognos Interview Questions (842)
 Informatica interview questions  Informatica Interview Questions (1622)
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions (29)
 Actuate interview questions  Actuate Interview Questions (35)
 Ab Initio interview questions  Ab Initio Interview Questions (168)
 Data Stage interview questions  Data Stage Interview Questions (563)
 SAS interview questions  SAS Interview Questions (550)
 Micro Strategy interview questions  Micro Strategy Interview Questions (35)
 ETL interview questions  ETL Interview Questions (195)
 Data Warehouse General interview questions  Data Warehouse General Interview Questions (215)
Question
what is normalization and denormalization
 Question Submitted By :: Data-Stage
I also faced this Question!!     Answer Posted By  
 
Answer
# 1
IN Normalization is controlled by elimination redundant
data where as in Denormalisation is controlled by redundant
data.
 
Is This Answer Correct ?    1 Yes 0 No
Somu
 
Answer
# 2
Normalisation is a Process of decomposing the tables into
number of succesive tables to avoid Data Retundancy and
Inconsistency
 
Is This Answer Correct ?    0 Yes 0 No
Shanu
 
 
 

 
 
 
Other Data Stage Interview Questions
 
  Question Asked @ Answers
 
What is mapping?   3
I have a source like file it have Number of records and i want to load without first and last records in target?Datastage? CSC 2
what is the difference between 7.1,7.5.2,8.1 versions in datastage? IBM 2
Can we use sequential file as source to hash file? Have you do it ?if what error it will give?   1
when we have to go for a sequential file stage & for a dataset in datastage?   1
how can or from where we can get reference data in scd type2 implementation? JPMorgan-Chase 2
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this? IBM 1
SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC? TCS 1
I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE? ME 4
country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display? Wipro 3
WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR PROJECT? GE 2
if ename='subbu' while running job the job should be abort how come? IBM 2
 
For more Data Stage Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com