Answer Posted / surya

new features in informatica 7.1 was

1. union transformation is added
2. custom ,, ,,
3. we can take flat file as lookup table
4.pmcmd command
5. server grid
6. transaction controle transformation
7. file repository concept
8.test load

What is session task and command task?

1288

---

Explain the different kinds of facts.

976

---

explain one complex mapping with logic? sales project?

6663

---

How to do unit testing in informatica? How to load data in informatica ?

1116

---

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1105

---

Enterprise data warehouse your projects phase by phase explain?

1917

---

What are the uses of etl tools?

1121

---

How can you define user defied event?

1026

---

What does update strategy mean, and what are the different option of it?

1085

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1273

---

What is the Process to creating lookup transformation in informatica

1040

---

Explain Dataware house architecture .how data flow from intial to end?

2578

---

How many input parameters can exist in an unconnected lookup?

1542

---

What is the command used to run a batch?

1058

---

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1062

---