I cleared Informatica certification Designer. if anybody
need dumps, can contact at mukesh1009@gmail.com
Answer Posted / lopa
Hi Mukesh,
Can u pls send me the dumps.
My mail id: lopamudrasahoo09@gmail.com
It will be helpful for me.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to extract sap data using informatica? What is abap? What are idocs?
What are the designer tools for creating transformations?
What are the popular informatica products?
What do you mean by worklet?
What are the reusable transformations?
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
Explain the shared cache and re-cache?
What are the performance considerations when working with aggregator transformation?
What are the types of schemas we have in data warehouse and what are the difference between them?
How we can use union transformation?
What is joiner transformation?
Different circumstance which drives informatica server to expel records?
What is xml source qualifier transformation in informatica?
How union transformation is used?
How can a transformation be made reusable?