Answer Posted / sn9999

HI

I am also looking to get certified in informatica. Can
someone please forward me the dump of all three
certificaions as well. my email is ahsan_0@hotmail.com

Thanks in advance

SN.

what make u disappointmnets in u r career

2198

---

Define slowly changing dimensions (SCD)?

1061

---

What do you understand by active and passive transformations?

942

---

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

1774

---

How many steps etl contains explain with example?

970

---

how do u set partition points in the mapping?

2597

---

Explain different types of partitioning?

1043

---

How to increase performance without changing anything in mapping.( In prod)

1264

---

Difference between flat files and relational sources?

2242

---

how many steps are there in etl process?

981

---

Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?

949

---

hoe to access second value in mapping parameter if it is having more than one value ?????????????

1540

---

What is partitioning? Explain different types of partitioning?

1242

---

What is a materialized view log?

999

---

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

2179

---