Answer Posted / ankita agarwal

Can u please mail me also the latest informatica
certification dumps .
id : ankitaga2000@gmail.com

thanks in advance :)

what is granularity in Data ware House?

1726

---

Explain about round-robi?

1149

---

When do we analyze the tables?

971

---

What are the steps involved in etl process?

1028

---

What is partitioning? Explain about round-robin, hash partitioning.

968

---

Explain the key challenges that you face while performing etl testing.

1009

---

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

2037

---

what are the reports developed in sap bw project and what is the requirement for developing it?

2179

---

what is the meant by Normalization and de-normalization?

2718

---

What are various etl tools in the market?

1008

---

Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

1773

---

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

1958

---

two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.

2056

---

when will use SQL override in a lookup transformation?

2294

---

can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?

2187

---