Answer / swetha

Simple Pass through maping :

Loads a static fact or dimension table by inserting all
rows. Use this mapping when you want to drop all existing
data from your table before loading new data.

Slowly Growing target :

Loads a slowly growing fact or dimension table by inserting
new rows. Use this mapping to load new data when
existing data does not require updates.

i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario

4 Answers   Polaris,

---

how we can update a target table without update strategy and update override?

3 Answers   TCS,

---

explain abt joiner t/r?

1 Answers   IBM,

---

Could any one to tell Fact table Partitioning?

2 Answers  

---

What are the join types in joiner transformation?

1 Answers   Informatica,

---

---

Slowly changing dimensions, types and where will you use them

0 Answers  

---

How many repositories can we create in Informatica??

9 Answers   IBM, Patni,

---

what is the architecture of any Data warehousing project?

5 Answers   IBM,

---

What is mapping debugger?

0 Answers  

---

How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.

1 Answers   Cognizant,

---

how to load rows into fact table in data warehouse

0 Answers   Informatica,

---

how to use incremental load?

2 Answers   TCS,

---