Answer Posted / manjunath

Stored procedure transformation is used to invoke the database procedure or function stored in the database. it needs the connection to the database. Where as the external procedure transformation is used to invoke the application function developed either in C/C++/VB.The external procedure needs to be bind with the external procedure transformation in the designer so the the application function would be loaded at the run time like a DDL.

Explain incremental aggregation in informatica

1185

---

What are the types of schemas we have in data warehouse and what are the difference between them?

986

---

How to join three sources using joiner?

1194

---

What is sequence generator transformation in informatica?

1125

---

Informatica settings are available in which file?

1041

---

What are pre and post-session shell commands?

1387

---

Can you generate sequence numbers without using the sequence generator transformation?

1162

---

Explain the aggregator transformation?

1221

---

Explain load alternative records / rows into multiple targets - informatica

1206

---

Define update strategy?

1315

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2087

---

What are the different lookup cache(s)?

1167

---

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

1112

---

How to load data in informatica ?

1068

---

What is lookup change?

1108

---