Can any body tell about the (UTC) unit
test cases with the examples in informatica.
Answer Posted / shashiall
prveen ..then where will we do SQL override?
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
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
if we have a delimiters at unwanted places in a flat file how can we over come those.
Whats there in global repository
What are the uses of etl tools?
what is $$$$?
What is enterprise data warehousing?
What is the benefit of session partitioning?
How would you join a node to the already existing domain?
Enlist few areas or real-time situations where informatica is required.
What are different types of transformations available in informatica?
What is standalone command task?
What is InformaticaPowerCenter?
How do you remove duplicate records in informatica? And how many ways are there to do it?
differences between service based and product based?
What is data transformation manager process?