Answer Posted / prasad
pmcmd
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the aggregator transformation?
What are the new features of informatica 9.x at the developer level?
Explain the pipeline partition with real time example?
Define mapping and session?
What do think which one is the better joiner or look up?
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 pushdown optimization $pushdownconfig parameter - informatica
Explain the mapping variable usage example in informatica
Name the different lookup cache(s)?
What is a sorter transformation?
What is the session task and command task?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
How can you increase the performance in joiner transformation?
Mention few power centre client applications with their basic purpose?