Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Design time, run time. If you don't create parameter what will happen
What are the types of caches in lookup? Explain them.
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is workflow? What are the components of workflow manager?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Clarify the utilization of aggregator cache record?
Explain transaction control transformation in informatica
What is substr in informatica?
have u done any performance tuning? how u ll do?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
what is index?how it can work in informatica
how tokens will generate?
In which transformation you cannot drag ports into it?
Explain how many types of dimensions are available in informatica?
