Answer Posted / senthil

hi
normally people using star schema in data warehousing
because it is de_normalized and easy way to retrieve data
from target and also understanding..
But snow flake is in fully normalized.normally OLTP
we use normalized ..

star schema used in data warehousing ..

Explain pmcmd command usage in informatica

1108

---

What is dimensional table?

1054

---

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1986

---

Which transformation should we use to normalise the COBOL and relational sources?

1182

---

What if the source is a flat-file?

1089

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1618

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10123

---

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

1097

---

What is the maplet?

1092

---

How we can create indexes after completing the load process?

1145

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2022

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5761

---

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

1093

---

How to update or delete the rows in a target, which do not have key fields?

1166

---

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

1245

---