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

wt is the difference between truncate and delete in which situation u use delete and truncate in real time..

4 Answers   TCS,

---

how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?

2 Answers   emc2,

---

what is galaxy repository?

2 Answers  

---

sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it

1 Answers  

---

If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?

2 Answers   TCS,

---

There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?

1 Answers   Wipro,

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

0 Answers   TCS,

---

What are partitions in informatica and which one is used for better performance?

2 Answers  

---

By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?

14 Answers   CSC, Emphasis,

---

Limitation of REPLACESTR. Is there any character limitation to it.

1 Answers   CTS,

---

how i will stop my workflow after 10 errors

2 Answers   HP,

---

(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance

1 Answers  

---