Answer Posted / manojkumar

Thanks Rayudu.

Is there any other reson why flat file load is faster than
table load.

I had an interview and even I said the same answer. But the
interviewer asked me "Is there any other reason ?" .
Interviewer didn't satisfied with this answer.

I hope there will be some other reason as well for this
question.
Anyways thanks for your reply.

How can we create index after completion of load process?

1108

---

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

2010

---

What is source qualifier transformation in informatica?

987

---

How can we delete duplicate rows from flat files?

1202

---

Write the different tools in the workflow manager?

1046

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1132

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6138

---

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

1103

---

How can you validate all mappings in the repository simultaneously?

1349

---

How to use procedural logic inside infromatica?

1196

---

What is persistent lookup cache?

1011

---

What is the fact table?

1048

---

How can you differentiate between powercenter and power map?

1069

---

How do you manage the Parameter files while migrating your data from one environment to another environment?

996

---

How do you handle two sessions in Informatica

1125

---