Answer Posted / vignesh muralidharan

three types of schemas are availble.Star schema,star flake
schema & snow flake schema.

Star schema:It is highly denormalised,so we can retrieve
the data very fast.

Star flake schema:Only one dimension contain one level of
hierachy key.

Snow flake schema:It is highly normalised,so retrievel of
data is slow.

Global and Local shortcuts. Advantages.

2035

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2050

---

Explain the mapping variable usage example in informatica

1167

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1274

---

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1325

---

What is the function of aggregator transformation?

1087

---

Why sorter is an active transformation?

1199

---

What are the steps involved in the migration from older version to newer version of Informatica Server?

2112

---

What are the components of the workflow manager?

1137

---

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

2280

---

How to create Target definition for flat files?

1228

---

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4730

---

What are the different transaction levels available in transaction control transformation?

1210

---

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2031

---

define galaxy repository in informatica

2232

---