Answer Posted / uma

select * from (select rownum rn,ename,job,sal
from emp)
where mod(rn,2) <> 0;

what are the Methods For Creating Reusable Transformations?

1175

---

what is INFORMATICA TESTING process

2294

---

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

2066

---

my source is junk data how will u remove that junk data by using unix please any one replay me

3704

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1167

---

Plz can any one say me how to get the informatica certification materials and dumps

2050

---

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10687

---

How do you convert single row from source into three rows into target?

1157

---

What is depict expression change?

1121

---

How can we handle two sessions in informatica?

1033

---

What is a sorter transformation?

1102

---

How to create Target definition for flat files?

1227

---

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9827

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

2008

---

What is the benefit of partitioning a session?

1182

---