Answer Posted / ganesh kumar

BY USING QUERY OVERRIDE IN SOURCE QUALIFIER
TO WRITE THE QUERY LIKE THIS

T_TEST UR SOURCE TABLE, NAME AND N_NUMBER UR SOURCE TABLE
COLUMN.

USING THE LEVEL PSEUDOCOLUMN TO GENERATE THE DUMMY ID(LEVEL
L)AND USING THE QUERY(DUAL TABLE) AS A INLINE VIEW AND THEN
JOIN(NON EQUIJOIN) THE CONDITION. FINALLY WE GOT THE RESUL

select t.name,t.n_number from t_test t,(select level l from
dual connect by level <= (select max(n_number) from t_test))
u where t.n_number>=u.l order by t.name;

SAME LOGIC USED FOR OTHER THAN RELATIONAL SOURCE AND THE
TRANSFORMATION.

Differentiate between joiner and lookup transformation?

1048

---

How many number of sessions can one group in batches?

1093

---

tell me 5 session failure in real time how can you solve that in your project?

2184

---

Which are the different editions of informatica powercenter that are available?

971

---

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

1013

---

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1991

---

What is fact table? Explain the different kinds of facts.

1010

---

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1072

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1908

---

What is the Process to creating lookup transformation in informatica

982

---

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2306

---

How can you generate reports in informatica?

972

---

What is the fact table?

993

---

What are the main features of Oracle 8i with context to datawarehouse?

2052

---

Define pmcmd command?

993

---