Answer Posted / maheshkumar bvn

first convert flat file to oracle table

create table num_test(field1 int,field2 int,field3
int,field4 int);

insert into num_test values(1000,null,null,null);
insert into num_test values(null,2000,null,null);
insert into num_test values(null,null,3000,null);
insert into num_test values(null,null,null,4000);



select max(field1),max(field2),max(field3),max(field4) from
num_test;

result:
1000 2000 3000 4000

How can you increase the performance in joiner transformation?

1248

---

Sequence generator, when you move from develoment to production how will you reset

2123

---

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1382

---

Explain about cumulative Sum or moving sum?

1091

---

What is native users?

1222

---

What are pre and post-session shell commands?

1387

---

which one is better performance wise joiner or look up

1149

---

What do you mean incremental aggregation?

1129

---

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2124

---

What is a sequence generator transformation?

1072

---

Separate from an archive server and a powerhouse?

1007

---

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

2796

---

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

1203

---

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1187

---

Differentiate between Load Manager and DTM?

2213

---