Answer Posted / chandra

by using normalizer we can normalize the data .
means a single input record can be devided into multiple
data records.

This process is also called as datta pivot.

Regards
chandrababu Naidu

How can we use mapping variables in informatica? Where do we use them?

1198

---

How to do unit testing in informatica? How to load data in informatica ?

1120

---

How can we update a record in the target table without using update strategy?

1144

---

Performance tuning in UNIX for informatica mappings?

2566

---

How to create or import flat file definition in to the warehouse designer?

1067

---

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

1109

---

Implementation methodology

1710

---

Explain about Informatica server process that how it works relates to mapping variables?

1076

---

How can you generate reports in informatica?

1026

---

What is a difference between complete, stop and abort?

1083

---

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1077

---

update strategy transformation in informatica

1064

---

What is rank index in rank transformation?

1078

---

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1493

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2420

---