Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

surrogate keys usage in Oracle and Informatica?

Question Posted / nalini pasupulati

Answers were Sorted based on User's Feedback



surrogate keys usage in Oracle and Informatica?..

Answer / ranjan

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 ?    6 Yes 0 No

surrogate keys usage in Oracle and Informatica?..

Answer / avinash kumar

If u have mulitiple records then for mentain this records we
need to generate surrogate key in informatica

Is This Answer Correct ?    6 Yes 0 No

surrogate keys usage in Oracle and Informatica?..

Answer / mahendra reddy ongole

surrogate key is system generated sequence numbers which
are used for maintaining the history in SCD-TYPE-2
applications

Is This Answer Correct ?    4 Yes 0 No

surrogate keys usage in Oracle and Informatica?..

Answer / palani

Its mainly used to maitain the uniqueness in the target
system that contains records from various source systems
ie. different source system may contain different keys as a
primary key.

Is This Answer Correct ?    1 Yes 0 No

surrogate keys usage in Oracle and Informatica?..

Answer / tanmoy

A surrogate key is the substitution of natural primary key

Is This Answer Correct ?    3 Yes 3 No

Post New Answer

More Informatica Interview Questions

What are the tasks that can be performed using sq?

0 Answers  

hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com

0 Answers  

how can u load the data in time dimension?

3 Answers  

what is meant by lookup caches?

2 Answers   Cap Gemini, Informatica,

HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com

2 Answers   TCS,

A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?

5 Answers   HP,

I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help

1 Answers   Axtria,

I want load the data into target with out 1st and last record.

5 Answers   Yash Technologies,

Why we use partitioning the session in informatica?

2 Answers  

Why do you use Mapping Parameter and mapping variable?

0 Answers  

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

0 Answers  

1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override

3 Answers   IBM,

For more Informatica Interview Questions Click Here
Categories