Answer Posted / satya

If we use Aggregator without using group by option we will
get only one row from source. It is a default charater of
Informatica.

e.g If there are 20 rows in the source table and only
using SQ and followed by Aggregator then target table then
the target table will be populated by the last row coming
from teh source table.

What is status code in informatica?

1063

---

How we can create indexes after completing the load process?

1198

---

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,

7232

---

Explain what are the different versions of informatica?

1143

---

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

2045

---

What is a repository manager?

1145

---

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2406

---

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?

1983

---

Write the program through which the records can be updated?

1053

---

What is a filter transformation and why it is an active one?

1015

---

How to elaborate tracing level?

1217

---

What does command task mean?

1214

---

What is the advantage of informatica?

1123

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1137

---

How to extract sap data using informatica? What is abap? What are idocs?

1248

---