Answer / ranjan

surrogate key is one type of key which is used to maintain
history .
it is used in slowly changing dimension (scd)

Answer / avinash kumar

If u have mulitiple records then for mentain this records we
need to generate surrogate key in informatica

Answer / mahendra reddy ongole

surrogate key is system generated sequence numbers which
are used for maintaining the history in SCD-TYPE-2
applications

Answer / palani

Its mainly used to maitain the uniqueness in the target
system that contains records from various source systems
ie. different source system may contain different keys as a
primary key.

Answer / tanmoy

A surrogate key is the substitution of natural primary key

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

0 Answers  

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

3 Answers  

What is data caches/ index caches?

0 Answers  

By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?

8 Answers  

What did you do in source pre load stored procedure

1 Answers  

What is the cumulative sum and moving sum?

0 Answers  

i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....

1 Answers  

How do you remove duplicate records in informatica?

1 Answers  

Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?

2 Answers   Zensar,

how to create a sample mapping for dynamic lookup transformation

2 Answers  

Hi, Can someone send me the DWH and Informatica FAQ's at vanibv6@gmail.com Thanks in Advance, Vani

2 Answers   Wipro,

Explain the difference between mapping parameter and mapping variable?

0 Answers