Transformer is a __________ stage
option1:Passive
2.Active
3.Dynamic
4.Static
Answer Posted / pavan
active
| Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
Mention a few design and development best practices for informatica?
How can we delete duplicate rows from flat files?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How to configure mapping in informatica?
How to Create a folder using pmrep command?
What is the difference between informatica 7.0 and 8.0?
What do you mean by filter transformation?
What is informatica metadata and where is it stored?
How to implement security measures using repository manager?
How to call shell scripts from informatica?
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
How to use procedural logic inside infromatica?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Explain the pipeline partition with real time example?