Answer Posted / yaseen

sort the records with sorter t/r and with aggregator t/r give the group by and add 1 column give the expression as count(col)and in router t/r give condition as count=1 for unique and default for duplicate.

And I think for dynamic lookup newlookport = 0 then it is for no changes right like
0------no changes
1-------insert
2--------update

Plz correct me if I am wrong

what is the hint? how to use it to reduce the query processing in program?

7766

---

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

2013

---

What is a standalone command task?

1179

---

difference between repository database and repository service?

1131

---

Why do we need informatica?

970

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1677

---

Sequence generator, when you move from develoment to production how will you reset

2010

---

How an expression transformation differs from aggregator transformation?

1022

---

How to generate or load values in to the target table based on a column value using informatica etl tool.

1050

---

What is data caches/ index caches?

1063

---

how we can load rejected record's at run time?(not through bad files)

2355

---

what are 3 tech challenges/ common issues you face?

2326

---

What is meant by query override?

1042

---

Explain the code page compatibility?

1049

---

What is an unconnected transformation?

1064

---