ALLInterview.com :: Home Page KalAajKal.com
 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                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Informatica
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question 
surrogate keys usage in Oracle and Informatica?
 Question Submitted By :: Nalini Pasupulati
I also faced this Question!!     Rank Answer Posted By  
 
  Re: surrogate keys usage in Oracle and Informatica?
Answer
# 1		 
surrogate key is one type of key which is used to maintain
history .
it is used in slowly changing dimension (scd)
 
Is This Answer Correct ?    0 Yes 0 No
Ranjan
 
  Re: surrogate keys usage in Oracle and Informatica?
Answer
# 2		 
If u have mulitiple records then for mentain this records we
need to generate surrogate key in informatica
 
Is This Answer Correct ?    0 Yes 0 No
Avinash Kumar
 
 
 
  Re: surrogate keys usage in Oracle and Informatica?
Answer
# 3		 
A surrogate key is the substitution of natural primary key
 
Is This Answer Correct ?    0 Yes 0 No
Tanmoy
 

 
 
 
Other Informatica Interview Questions
 
  Question Asked @ Answers
 
In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions. Wipro1
Explain the flow of data in Iinformatica?  1
How do you take care of security using a repository manager  2
What are the phases in SDLC?  2
how to run the batch using pmcmd command Wipro1
how do u move the code from development to production?  2
What are the data movement modes in informatcia?  1
Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance, Tech-Mahindra4
in which situations do u go for snowflake schema ? TCS1
What are the types of maping in Getting Started Wizard?  1
After we make a folder shared can it be reversed?Why? Accenture1
in which situations do u go for sequence generator ? TCS2
What is the filename which you need to configure in UNIX while installing infromatica? Accenture2
What are the rank caches?  2
What is the target load order?  2
What are slowly changing dimensions? Verinon-Technology-Solutions3
What is the difference between Oracle performance and Informatica Percfomance? Which performance is better? IBM2
What is Micro Strategy? Why is it used for?  1
how to duplicates from expression transformation without using sorter before that  1
What is polling?  1
 
For more Informatica Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com