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.

what is bridge tables in informatica

1 Answers   CTS,

---

Whats there in global repository

0 Answers  

---

how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)

2 Answers   Sonata,

---

how do u tune queries?

1 Answers  

---

without using emailtask how will send a mail from informatica?

3 Answers  

---

---

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

0 Answers  

---

Why use the lookup transformation ?

2 Answers   Informatica,

---

In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?

1 Answers  

---

Explain constraint based loading in informatica

0 Answers   Informatica,

---

What is meant by lookup transformation?

0 Answers  

---

in my source table i want to delete first and last records and load in between records into target? how can it possible?

3 Answers   HCL, Thomson Reuters,

---

What is meant by active and passive transformation?

0 Answers  

---