Answer Posted / gd

First override source qualifier
Select * from emp where deptno in(10,20,30);

Next sorter T/r sort on salary column desc

Then rank T/r set rank properties top and number of ranks is 5

target achieved

What is olap (on-line analytical processing?

632

---

What are data-driven sessions?

709

---

How to do unit testing in informatica? How to load data in informatica ?

641

---

Can we override a native sql query within informatica?

622

---

What is event and what are the tasks related to it?

605

---

---

Tell me about Propagate functions in informatica

518

---

What is the Process to creating lookup transformation in informatica

574

---

Explain in detail scd type 2 through mapping.

607

---

Explain the tuning lookup transformation - informatica

607

---

Explain direct and indirect flat file loading (source file type) - informatica

815

---

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

3438

---

Is stop and abort are same in informatica?

566

---

what is size of u r database?

1844

---

What does “tail –f” command do and what is its use as an Informatica admin.

625

---

what is index?how it can work in informatica

1574

---