Answer / murali

the surrogate key is the primary key used to avoid the
problem of critical column. let me clarify u with example...

table A:
Cust_no(PK) Cust_name Loc
100 X Mumbai

this is what ur OLAP DHW is having abt Customer X

But, he has changed his address from X to Y. U have to
update this in ur OLAP DWH. then, i u try to insert this
into ur Table A,
Error: Prinary key Constraint violated (Coz,PK is same for
the both the records)... then, LOC is the Critical Column.
to avoid this, we need to generate a primary key either by
user defined or system generated.

Answer / dr.jornalist

Surrogate Key:- Surrogate key is a system generated primary
key used in informatica for maintaining history of values.

Answer / kalpana

Some times the primary constraint may violate at that time
we go for surrogate key.

Answer / soujanya

surrogate key is the system generated key to avoid primary
key conatraint.

Answer / kalpana

the above one is primary key constraint

Answer / raghureddy

It has system generated artificial primary key values .
which allows to maintian historical data in dwh

can u any challenge your project?

0 Answers   HP,

Explain reference cursor?

1 Answers  

Slowly changing dimensions, types and where will you use them

0 Answers  

get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c

0 Answers   Infosys,

list out all the transformations which use cache?

0 Answers   Informatica,

write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000

8 Answers   TCS,

what is unit testing?tell me proceedure

0 Answers   L&T, UST,

we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?

2 Answers  

Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga

2 Answers  

What are the types of error logs available in Informatica?

1 Answers  

What are the types of data that passes between informatica server and stored procedure?

1 Answers   Informatica,

i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?

1 Answers   HCL,