Answer Posted / atanu

Please send me the Dumps for Informatica power center developer certification Dump to my mail(atanuswpal99@gmail.com)

Thanks & Regards
Atanu

How can we use external procedural logic in informatica?

924

---

What is etl tool in hadoop?

894

---

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?

2036

---

What is fact? What are the types of facts?

1117

---

what do u do when DB time takes more?in sap bi

2205

---

State the differences between shortcut and reusable transformation

1056

---

What is partitioning? Explain different types of partitioning?

1242

---

what is the difference between cardinality and Nullability?

3453

---

how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)

2698

---

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

1966

---

Do we need an ETL tool? When do we go for the tools in the market?

966

---

Explain about the data integration suite features?

946

---

What is initial load and what is full load?

988

---

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

1009

---

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

---