What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?350
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?484
What if the source is a flat-file? Then how can we remove the duplicates from flat file source?1 446
tell me the rules and responsblites in our project(my project is development)
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Explain what are the different versions of informatica?
What are the types of lookup transformation?
What is the sql query overwrite in source qualifier in informatica
What is sq transformation?
What is the difference between informatics 7x and 8x and what is latest version?
Plz can any one say me how to get the informatica certification materials and dumps
Did u used latest transformations of 8.6.0? for what?
tell me about your project functionality
What is complex mapping?
Explain the scenario which compels informatica server to reject files?
What does role playing dimension mean?
How do you load first and last records into target table?
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