What is the difference between normal and bulk loading? Which one is recommended?

1 Answers  

---

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  

---

How can you generate reports in informatica?

0 Answers  

---

what happens when a batch fails?

3 Answers  

---

I want expect first and last record remaining all records will be loaded into target? which transformations we can use?

6 Answers   Cap Gemini, CTS,

---

---

Quickly characterize reusable change?

0 Answers  

---

What happens if the info. Server doesn't find the session parameter in the parameter file?

1 Answers  

---

What is confirmed dimension with scenario

1 Answers   HCL,

---

Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer

3 Answers   TCS,

---

As union transformation gives UNION ALL output, how you will get the UNION output?

0 Answers   Informatica,

---

generate date / time dimension in informatica

0 Answers   Informatica,

---

What is the use of transformation?

0 Answers  

---