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.

If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?

4 Answers  

---

IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?

2 Answers  

---

explain different levels in pushdown optimization with example?

2 Answers   TCS,

---

What are the uses of etl tools?

0 Answers  

---

What is the difference between Bitmap and Btree index?

3 Answers   Mind Tree,

---

What is status code?

2 Answers  

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

1 Answers   IBM,

---

Can we make worklet inside worklet?

1 Answers  

---

3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?

7 Answers   Accenture,

---

How will u find weather dimension table is big in size of a fact table?

1 Answers  

---

What are the different lookup cache(s)?

0 Answers  

---

what is the use of Data Mart?

5 Answers   IBM,

---