Answer Posted / deepthi

Few more additions to the above answers.....

Confirmed dimension: Dimesion which can be 100 % sharable
with other star schemas. In other terms it is connected to
more than one one fact table .

Ex: time dimension

Junk dimesion: stores low cordinality values (repeated
values),flagged values.
Ex: details of gender information(male/female)

Degenerated Dimension:The attribute in the fact table
directly comes from the source table not from any
dimensions called degenerated dimensions. these are also
called neither a dimension nor a perfect fact.

Ex:attribute order_no, comes from source

Slowly changing Dimensions:Dimesions which are changing
over a period of time called slowly changing dimensions.

Ex:salary of employee.

what is the hint? how to use it to reduce the query processing in program?

7633

---

Briefly describe lookup transformation?

982

---

What is status code in informatica?

959

---

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

2186

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1630

---

What are the different types of repositories created using informatica?

1062

---

What is an active transformation?

1038

---

What is the command used to run a batch?

996

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2182

---

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3817

---

What is joiner change?

1078

---

How to do the error handling of if ur source is flatfiles?

1913

---

Can we override a native sql query within informatica?

989

---

Explain lookup transformation in informatica

1007

---

What is the surrogate key?

1148

---