Answer Posted / venubyna1

using Update strategy

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2020

---

Explain the etl program with few examples.

1031

---

How can we update a record in the target table without using update strategy?

1123

---

How can you generate reports in informatica?

1005

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7166

---

How an expression transformation differs from aggregator transformation?

1025

---

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

1105

---

How are the sources and targets definitions imported in informatica designer?

1090

---

When do you use sql override in a lookup transformation?

1079

---

What is a sequence generator transformation?

1000

---

my source is junk data how will u remove that junk data by using unix please any one replay me

3685

---

explain about unit testing? in real time?

2181

---

Why is sorter an active transformation?

1101

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1493

---

where to store informatica rejected data?

1080

---