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.

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2170

---

Describe an informatica powercenter?

1194

---

What is meant by incremental aggregation?

1185

---

What is dimensional table?

1133

---

What is the use of transformation?

1056

---

How you can differentiate between connected lookup and unconnected lookup?

1107

---

have u done any performance tuning? how u ll do?

2366

---

Differentiate between source qualifier and filter transformation?

1631

---

What is pmcmd command?

1182

---

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

1212

---

Explain what is informatica metadata and where is it stored?

1108

---

What do you mean by blocking transformation?

1118

---

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1180

---

Explain sessions?

1140

---

How do you load alternate records into different tables through mapping flow?

1928

---