Answer Posted / smitha

Hi Mukesh,

This is Smitha. I got to give Informatica certification soon by May2014. Could you please mail the related dumps to smithakachroo@gmail.com. Will the questions change if I take exam in May2nd week?

Thanks in Advance.

in reporting we add some new objects,how we get the count of the newly added objects to the report

2189

---

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2740

---

What do you understand by a term domain?

1123

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

1804

---

What are the advantages of using informatica as an etl tool over teradata?

1018

---

What is a dimensional model?

976

---

What are the new features of informatica 9.x developer?

966

---

What are the components of the workflow manager?

1126

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6170

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5785

---

Explain incremental aggregation in informatica

1121

---

Is there any way to read the ms excel datas directly into informatica?

1020

---

CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

9109

---

How does the aggregator transformation handle null values?

1145

---

How can we improve session performance in aggregator transformation?

1105

---