Answer / abhinaw prakash

surrogate key is used to avoid the critical column.critical
column means the column which makes the analysation or data
wrong for example assume one customer table
cust_id(p.k) cust_name amount loc
1 jones 1000 hyd
he purchase the product in hyd by 1000/- if he again
purchase by 2000/- in pune not in hyd.then we have to
create another record in that table with same cust_id but
here cust_id is having primary key so we are unable to
create a new record for suppose if u update the record u
got the wrong information as
1 jones 3000 pune
so eliminating this we are maintian the another column like
cust_no as surrogate key (unique value)and removes p.k in
cust_id.surrogate key is like an index.

Answer / vijaya

surrogate is acts as a primary key. some times we want to
maintain historical information of particular product or
anything. for eg, a product costs 20rs in the month of may
and next month it costs 25rs. in this case if we want to
maintain both records with same product_id then it cant be
possible if product_id is primary key. In this case we use
concept of surrogate key. like
skey prod_id price month
1 101 20 may
2 101 25 june

in informatica this concept is used in update strategy.

Answer / mahesh manam

The main purpose of SURROGATE KEY is:

--> If you want to store the multiple records
for example:
In one general store customer id is primary key ,
If the customer change his address or phone number .
But now our requeriment is like to store all the data along
with old


-->If you are using duplicate records with out using
SURROGATE KEY like as follows:

ID NAME LOC
1 Mahesh Chennai
1 Mahesh Hyderabad


In above case if you are work with any dimmension model it
is not support to use this table. So, we need to maintain
Primary Key in each table.

-->Surrogate key is a key in that table use as a primary
key in the table to do joininng to another

-->Surrogate is very usefull and Quickly
If you are using any huge amount of data and you need to
retrive the queries which is usefull to your bussiness

Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?

3 Answers   Deloitte, TCS,

---

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  

---

Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into it. The records already is in flatfile is getting override. I don't want to override existing records. Note : we can do this by implementing CDC / Incremental pool logic if target is relational . But this is flatfile. So, even i use this same technique it will override only So what is the solution ? Is there any option at session level for flatfile target ? Advance Thanks

4 Answers   IBM,

---

why union transformation is active transformation?

6 Answers   IndiGo, TCS,

---

If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks

7 Answers   Puma,

---

how can u avoid duplicate rows in flat file?

4 Answers   CTS, Wipro,

---

what is flat file override?

1 Answers   Cap Gemini, HP,

---

what is fact table?

9 Answers  

---

can session assigned multiple mappings or not?

2 Answers   Zensar,

---

What are data-driven sessions?

0 Answers  

---

What is the difference between STOP and ABORT options in Workflow Monitor?

0 Answers  

---

how can u load the data in time dimension?

3 Answers  

---