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

What is an unconnected transformation?

1067

---

How to create the source and target database connections in server manager?

1071

---

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8207

---

What are the guidelines to be followed while using union transformation?

1121

---

What is the maplet?

1092

---

Explain pmcmd command usage in informatica

1108

---

what is size of u r database?

2294

---

what are the deliverables?in your project?

2131

---

What does role playing dimension mean?

1035

---

Describe data concatenation?

1062

---

What are the different transaction levels available in transaction control transformation?

1171

---

What is data transformation manager process?

1133

---

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1055

---

In informatics server which files are created during the session rums?

1107

---

What is a rank transform?

1072

---