Answer / pradeeshkumar

Loading duplicate records into a target table which has a
primary key is just a height of Brain failure.
The concept of primary key itself fails. If you still want
to insert it, better don't have any primary key

Answer / jay

Is that primary key column in the target is different,
than this is called surrogate key which is obtained
from Sequential generator (with or without combination of
key value from source. if combined with source primary key
column, then it is known as creating frequency for
each source primary column value)

1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override

3 Answers   IBM,

---

Separate from a database, an information bazaar, and an information stockroom?

0 Answers  

---

what happens if you try to create a shortcut to a non- shared folder?

1 Answers  

---

If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?

4 Answers  

---

Explain the different lookup methods used in informatica?

0 Answers  

---

can you use flat file for lookup table?why?

2 Answers   HCL,

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

0 Answers   Informatica,

---

if i have a delimited file as source so how can we seperate this file into three diff targets?

2 Answers   TCS,

---

without dynamic lookup how to insert new rows and update existing rows?

1 Answers   HP,

---

How to merge First Name & Last Name?

8 Answers  

---

what is the command to get the list of files in a directory in unix?

5 Answers   iGate,

---

If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?

1 Answers   TCS,

---