Answer / koti

sarrogate key is ssystem generated sequence number,an
artificial key. which can be used in maintaing the history
of the data

Answer / sunil kumar singh

Surrogate Key is artificial that is created for
datawarehousing for generating the unique number for each
record. Surrogate key works on the behalf of primary key.
And main purpose of surrogate key is to maintain the
historical record.

Answer / nivas

Surrogate key is a system generated sequence numbers. It is
also called artificial key.Sarrogate key using as a primary
key without using sarrogate key we can't do SCD type2
implemenation.

Answer / rajat singh

Surrogate key is the primary key for the Dimensional table.
Surrogate key is a substitution for the natural primary key.

Data warehouses typically use a surrogate, (also known as
artificial or identity key), key for the dimension tables
primary keys. They can use Infa sequence generator, or
Oracle sequence, or SQL Server Identity values for the
surrogate key.

It is useful because the natural primary key (i.e. Customer
Number in Customer table) can change and this makes updates
more difficult and also used in SCDs to preserve historical
data.

Answer / shan

sarrogate key is ssystem generated sequence number,an
artificial key. which can be used in maintaing the history
of the data

Answer / ram

surrogate key
is a series of sequential numbers assigned to be foreign key
for the table

Answer / anil

Surrogate key is a primary key which can be used for
sequence

Answer / latha

actually it appears in picture when a critical
column(example location) occurs in a table.In order to avoid
the critical column we are using surrogate key.surrogate key
is also a primary key.

Answer / swagatika

IN DWH environment,Every dimension table is integrated with surrogate key,which is byforced created to maintain the consistancy of data warehouse targets.It never generate the alfa numeric number of primary key & also replace the missing values.
The natural primary key ,which is coming from database is considered as alternate key in DWH Environment

how do u move the code from development to production?

3 Answers  

hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

5 Answers   TCS,

Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.

5 Answers   Accenture, VAMA,

If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?

8 Answers   HeadStrong, TCS,

hi all, Can anyone please tell me the relationship between informatica and business objects

1 Answers  

What is the benefit of session partitioning?

0 Answers  

comonly how meny mappings r there in Banking projects?

1 Answers  

In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.

2 Answers   Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,

can we load the data with out a primary key of a table? what is target plan?

6 Answers   IBM,

How many numbers of sessions can one group in batches?

0 Answers  

Different qualification between a related rotate toward the sky and isolates look upward?

0 Answers  

Different circumstance which drives informatica server to expel records?

0 Answers