What is a surrogate key?Why we use it in a mapping?Pl give an example.

4 Answers   PCS,

---

What are the different lookup cache(s)?

0 Answers  

---

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  

---

Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..

1 Answers  

---

How do you load unique records into one target table and duplicate records into a different target table?

0 Answers  

---

what are the unix commands to start the wrk flow ?

4 Answers   Accenture, TCS,

---

what are the reusable tasks in informatica ?

11 Answers   CTS, HP, IBM, TCS,

---

How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks

2 Answers   Puma,

---

What is the status code?

1 Answers  

---

i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?

6 Answers   Thomson Reuters,

---

What is diff joiner and lookup

4 Answers   BirlaSoft,

---

What is a connected transformation?

0 Answers   Informatica,

---