Answer Posted / santosh

*You cannot include the following objects in a mapplet:

1.Normalizer transformations
2.COBOL sources
3.XML Source Qualifier transformations
4.XML sources
5.Target definitions
6.Other mapplets
7.Pre- and post- session stored procedures

What does refresh system mean, and what are its distinctive choice?

1072

---

What is rank transformation in informatica

1108

---

What are the static cache and dynamic cache in informatica?

1139

---

What are the performance considerations when working with aggregator transformation?

1094

---

Target increases every day even though no new record was inserted

1514

---

What do you mean by enterprise data warehousing?

1002

---

What does reusable transformation mean?

1069

---

What are the components of the workflow manager?

1079

---

what is the difference between informatica6.1 and infomatica7.1

2182

---

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1049

---

How can you differentiate between powercenter and power map?

1018

---

How do you load unique records into one target table and duplicate records into a different target table?

1163

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2209

---

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

2063

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2053

---