Answer / isha

We can use contraint based loading in that case and after loading all the dimensions table we can load the data into fact table.

What are the rank caches?

2 Answers   Informatica,

---

What is the Difference between sorter and aggregator?

2 Answers  

---

Define mapping and session?

0 Answers   Informatica,

---

write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24

2 Answers   HP,

---

Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!

1 Answers  

---

What is informatica? Why do we need it?

0 Answers  

---

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

0 Answers  

---

What happens if we dont select data driven option?

2 Answers   Zensar,

---

Diffrence between static and dynamic cache

2 Answers   HCL,

---

In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?

4 Answers  

---

if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target

5 Answers   TCS,

---

What is the difference between view and materialised view?

4 Answers  

---