Answer Posted / arpan

Select empid,monthyear,sal from empsal
where sal>100000
orderby monthyear;

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1113

---

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

2231

---

What is session task and command task?

1395

---

What is standalone command task?

1374

---

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,

7235

---

Under what condition selecting sorted input in aggregator may fail the session?

1175

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2193

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1145

---

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2901

---

Enlist the various types of transformations.

1121

---

Reusable transformation and shortcut differences

1881

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2290

---

Performance tuning in UNIX for informatica mappings?

2623

---

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

1015

---

explain one complex mapping with logic? sales project?

6733

---