tell me the rules and responsblites in our project(my project is development)

1279

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

381

Explain what are the different versions of informatica?

403

What are the types of lookup transformation?

431

What is the sql query overwrite in source qualifier in informatica

407

What is sq transformation?

385

What is the difference between informatics 7x and 8x and what is latest version?

346

Plz can any one say me how to get the informatica certification materials and dumps

1382

Did u used latest transformations of 8.6.0? for what?

1283

tell me about your project functionality

1659

What is complex mapping?

386

Explain the scenario which compels informatica server to reject files?

401

What does role playing dimension mean?

398

How do you load first and last records into target table?

362

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

7056