Answer / prabhu

audit table is the table used to moniter the statistics of
session and workflow.You can populate audit tables by using
pmcmd command or by using repository tables

Prabhu
www.iskilltech.com

Answer / sameer

We uses audit table in real time because audit table gives all information abt.our project Means
Sourge success rows,target success rows,source failed rows, target failed rows,transformation error best on requirement we can calculates.

Issue with Update override at Target table in Informatica.

2 Answers  

---

how can i invoke pmcmd in command line prompt

1 Answers  

---

what is upstream and downstream transformation?

7 Answers  

---

Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.

2 Answers  

---

can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?

1 Answers   Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,

---

Can informatica load heterogeneous targets from heterogeneous sources?

0 Answers  

---

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,

0 Answers   HCL,

---

How does a sorter cache works?

0 Answers  

---

What is the Process to creating lookup transformation in informatica

0 Answers   Informatica,

---

i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0

2 Answers   TCS,

---

What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.

1 Answers   Zensar,

---

A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )

1 Answers  

---