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.

Different sorts of metadata that stores in the storage facility?

0 Answers  

---

What is the advantage of persistent cache? When it should be used.

1 Answers   Wipro,

---

I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.

4 Answers   Cap Gemini, IBM,

---

What is a grid in Informatica?

0 Answers  

---

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

3 Answers   Cap Gemini,

---

If u r using dynamic cache lookup port will be thier in thet which option u will select

1 Answers   HCL,

---

where to store informatica rejected data?

0 Answers  

---

how can you load data into target table without leading zeor's

4 Answers   Deloitte,

---

I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,

3 Answers   CSC,

---

What are the types of lookup?

3 Answers   Wipro,

---

What is synonym?

2 Answers   Patni,

---

Can you start a session inside a batch individually?

2 Answers  

---