Answer Posted / n.bandaru
Yes, I agree above answers.
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Explain the shared cache and re-cache?
How to load a Dimension ? and how to load a fact table?
what is the size of u r source(like file or table)?
What if the source is a flat-file?
What is incremental aggregation?
How to do the error handling of if ur source is flatfiles?
What is an expression transformation?
What is the difference between stop and abort in informatica
What is the need of etl tools?
Where can we find the throughput option in informatica?
what is mean by complex business rule ?
How does a rank transform differ from aggregator transform functions max and min?
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 update or delete the rows in a target, which do not have key fields?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab