Answer Posted / jz

Select Distinct Box at Source propeties level or jus
override sql in Session.

What is status code in informatica?

584

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1705

---

Is it possible to define a single node as a Gateway node as well as worker node?

656

---

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?

5572

---

State the differences between sql override and lookup override?

622

---

---

What is a predefined event?

658

---

What is a pre-defined event and user-defined event?

577

---

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

1910

---

How to delete duplicate row using informatica?

607

---

What could be the possible resons of locks by user?

662

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

1761

---

Explain the features of connected and unconnected lookup.

544

---

what is diff b/t sorter t/r and agg have the option sorter property...

1746

---

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1621

---

What are the types of lookup transformation?

629

---