Answer Posted / chowdary

The main differences between Informatica7.1 & 8.1 is
1.Java transformation support
2.Extended expression library&user defined functions
3.Mapping templates
4.Global and web based administration console

What is fact table? Explain the different kinds of facts.

1122

---

what is $$$$?

2202

---

Can we create multiple integration service on single repository?

1240

---

Explain load alternative records / rows into multiple targets - informatica

1202

---

generate date / time dimension in informatica

1160

---

What is joiner transformation in informatica?

1097

---

How is union transformation utilized?

1058

---

What is the need of etl tools?

1178

---

EXL informatica Questions

1443

---

How to create the source and target database connections in server manager?

1129

---

What are the different ways to implement parallel processing in informatica?

1479

---

what is the hint? how to use it to reduce the query processing in program?

7965

---

What are the types of caches in lookup? Explain them.

1009

---

Can you use flat files in Mapplets.

2710

---

write a query to retrieve the latest records from the table sorted by version(scd)

1110

---