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 to call stored Procedure from Workflow monitor in Informatica 7.1 version?

1 Answers   Accenture,

how you will maintain version?

3 Answers   CTS, TCS,

In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?

6 Answers   IBM,

You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000

7 Answers   Deloitte,

how can import the data from the flat files?

2 Answers  

What are the two modes of datamovement in informatica sever?

2 Answers  

Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.

5 Answers  

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE

2 Answers   Wipro,

What is CDC? How to implement CDC?

4 Answers   People Tech, TCS,

What is the benefit of session partitioning?

0 Answers  

What are batches?

0 Answers  

To import the flat file definition into the designer where should the flat file be placed?

0 Answers   Informatica,