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 (756)
 Cognos interview questions  Cognos Interview Questions (851)
 Informatica interview questions  Informatica Interview Questions (1624)
 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 (172)
 Data Stage interview questions  Data Stage Interview Questions (564)
 SAS interview questions  SAS Interview Questions (556)
 Micro Strategy interview questions  Micro Strategy Interview Questions (36)
 ETL interview questions  ETL Interview Questions (195)
 Data Warehouse General interview questions  Data Warehouse General Interview Questions (216)
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
 
1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?   1
how can u find out the datastage job is running on how many nodes IBM 6
How to Convert the columns into rows?   2
Hi every one, I am Suneel. I/p o/p --- ----- suneel suneel suneel suneel suneel suneel how it will get. Please design job with explain. Thanks. AMDOC 3
job locking methods? How can we unlock the job? IBM 2
Out of 4 mill records only 3 mill records are loaded to target and then job aborted. How to load only those 1 mill(not loaded records) for next run. This job is not sequential job, it is stand alone parallel job.What are the possibilities available in datastage8.1? IBM 6
where we use column generator stage in real time scenario? TCS 5
Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY? TCS 2
what is the difference between 7.1,7.5.2,8.1 versions in datastage? IBM 2
How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?   1
if we take 2 tables(like emp and dept), we use join stage and how to improve the performance? Cap-Gemini 5
What are the prerequisites for join stage   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