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 >> Cognos
  2. Suggest New Category

what use of surgate key in project

Question Posted / pradeep

Answers were Sorted based on User's Feedback



what use of surgate key in project..

Answer / kumar

Hi,

Surrogate are System generated sequential Values.

We use these keys to maintain the Historical data in EDW&
to set up relationship between Dimension Table & Fact Table.
It plays a key role in Maintain Historical data in EDW.

We prefer these Keys Even we have the Primary key Columns
in the Tables, since a customer may purchase several times
in a single day irrespective of time & Bill No. are
different.
In this situation we take these keys that give different
No. for several times Purchase in a single day.

Is This Answer Correct ?    4 Yes 0 No

what use of surgate key in project..

Answer / sindhuchowdary5

Surgate is a system generator sequence,by using this we can
store the historical data tha means it stores the type 2 data,
it acts as primary key in dimension table

Is This Answer Correct ?    1 Yes 1 No

what use of surgate key in project..

Answer / fgdfgd

Surgate is a system generate key , using this key we can maintain historical data in DWH .

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Cognos Interview Questions

Hi, How the relations will be exists in DMR models if u have any idea please explain me

2 Answers   Polaris,

i wanna some client names and project names in cognos? plz send cognos resumes(3+) exp plz plz plz help me??

1 Answers   TCS,

How we check the errors before running the report,plz let me know the answer

4 Answers   TCS,

write the sql query to display 5th and 10th row in a table?

5 Answers   CTS, IBM,

how u migrate the reports from impromptu to reportnet???

3 Answers   Wipro,

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this

2 Answers  

How to maintain Query subject’s relationships between Database layer and Model Layer? For eg - if 2 DB layer's query subjects are copied in Model Layer - Query subjects respectively, then Where should we define relationship of both Query subjects? Either in DB layer or Model layer?

0 Answers  

How can you improve performance in report studio level? What is the difference between Cognos sql and Native sql? How can you create cubes in framework manager?

7 Answers   Genpact, iFlex, TCS,

How will u execute a stored procedute from a reportstudio

2 Answers   Cap Gemini,

How can you schedule the report that it displays a day old data. (My answer was to create a view, but the lady wanted some other method).

1 Answers  

difference between drill through and master detail report?

2 Answers   HCL, Zensar,

What are the components used in web tier?

0 Answers  

For more Cognos Interview Questions Click Here
Categories