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 (178)
 Business Objects interview questions  Business Objects Interview Questions (750)
 Cognos interview questions  Cognos Interview Questions (838)
 Informatica interview questions  Informatica Interview Questions (1617)
 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 (562)
 SAS interview questions  SAS Interview Questions (549)
 Micro Strategy interview questions  Micro Strategy Interview Questions (35)
 ETL interview questions  ETL Interview Questions (193)
 Data Warehouse General interview questions  Data Warehouse General Interview Questions (214)
Question
what is normalization and denormalization
 Question Submitted By :: Raaam.chowdary
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is normalization and denormalization
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
 
  Re: what is normalization and denormalization
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
 
Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result as values before the delimiter should come under the column ITEM_CODE and values after the delimiter should come under the column LOC_CODE.. But some datas like "SCH-AS-1010", for this, "SCHAS" should come under the column ITEM_CODE and 1010 should come under the column LOC_CODE.. Pls help me..   1
i having source like emptable,dept table and combined purpose using for the join stage but join stage which partition techq will be prefored? pls given the ans? Wipro 2
what is diff b/w datastage 8.1,8.5,8.7? ibm 1
How did you reconcile source with target? HP 2
How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement? IBM 1
how can we create a Sorrogate key in transformer stage? I want it in parallel mode Syntel 2
Tell me Wt main advantage of Stage varibles? Project level hints? Hexaware 4
how can we create tables in datastage?   1
How to display all the duplicate records from the oracle Table? IBM 2
What are the unit test cases you used in your project? CSC 1
what is mapping lookup   1
tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin? Infotech 3
 
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