Answer Posted / usha

1.Confirmed Dimension:- the dimensions that are bult once
and can be use reused in multiple fact tables

2.Junk Dimension:- the dimension which is used to cerate
junk attributes

3.Degenerated Dimension:- The dimension that are located
in fact table


4.Slowly changing Dimensions:- The dimensions that chaanfes
slowly over a period of time.

Types

SCD type1
SCD type2
SCD type3

What are the limitations of joiner transformation?

1114

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1977

---

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2070

---

How can you define user defied event?

1032

---

What is the function of look up transformation?

1125

---

Does an informatica transformation support only aggregate expressions?

1043

---

How do you load first and last records into target table?

1159

---

What are the static cache and dynamic cache in informatica?

1195

---

How to improve the performance of a session using sorter transformation?

1148

---

Explain the aggregator transformation?

1169

---

How can we use batches?

1026

---

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

2237

---

Scheduling properties,whats the default (sequential)

1959

---

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?

2268

---

 Informatica Checkpoints

3334

---