Answer Posted / venky

select * from emp e where &n=(select count(distinct(b.sal))
from emp b where e.sal=b.sal);

How does a sorter cache works?

1075

---

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2747

---

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1785

---

What is meant by incremental aggregation?

1109

---

What is the commit type if you have a transaction control transformation in the mapping?

1033

---

What is the benefit of partitioning a session?

1182

---

What is olap (on-line analytical processing?

1071

---

what is the -ve test case in your project.

2407

---

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

4164

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2125

---

What do you mean by blocking transformation?

1044

---

What is meant by query override?

1061

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1086

---

What is deployment group?

1218

---

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2458

---