:: 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                      
Categories >> Software >> Data Warehouse >> Informatica


 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 (551)
 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 (215)
what is normalization? explain 1st NF, 2nd NF, 3rd NF
 Question Submitted By :: Informatica
I also faced this Question!!     Answer Posted By  
# 1
Data normalization is a process in which data attributes
within a data model are organized to increase the cohesion
of entity types. In other words, the goal of data
normalization is to reduce and even eliminate data
redundancy, an important consideration for application
developers because it is incredibly difficult to stores
objects in a relational database that maintains the same
information in several places.


First normal form (1NF)
An entity type is in 1NF when it contains no repeating
groups of data.

Second normal form (2NF)
An entity type is in 2NF when it is in 1NF and when all of
its non-key attributes are fully dependent on its primary

Third normal form (3NF)
An entity type is in 3NF when it is in 2NF and when all of
its attributes are directly dependent on the primary key.

Is This Answer Correct ?    15 Yes 2 No

Other Informatica Interview Questions
  Question Asked @ Answers
How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?   2
what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?   1
how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target) tcs 3
we have to use order by,where,having we to implement sql query Satyam 1
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c Infosys 3
What are the new features of informatica 7.1?   2
if i have a delimited file as source so how can we seperate this file into three diff targets? TCS 1
What is up date strategy and what are the options for update strategy?   2
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID   1
I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type, CSC 3
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..! TCS 3
Can we run session without using workflows? TCS 5
For more Informatica Interview Questions Click Here 

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