Answer Posted / pradosh
this is a stupid Question,
informatica is a ETL tool which is extract,transfoemation,and load data from source to target,bcz our project based on informatica tool so we used
Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What does role playing dimension mean?
What are the different ways to implement parallel processing in informatica?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What is the procedure for creating independent data marts from informatica 7.1?
How do we call shell scripts from informatica?
How to update source definition?
What do you mean by channel change?
Enlist the tasks for which source qualifier transformation is used.
What is exclusive and normal mode for repository services?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is the reusable transformation?
differences between service based and product based?
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
What is the cumulative sum and moving sum?
How to implement security measures using repository manager?