Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / anil
Surrogate key is a primary key which can be used for
sequence
| Is This Answer Correct ? | 7 Yes | 7 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
What are roles and groups and benefits of using them?
In how many ways we can create ports?
What are the various types of transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Differentiate between reusable transformation and mapplet.
Global and Local shortcuts. Advantages.
Differentiate between a repository server and a powerhouse?
What is Data Caches size?
Explain what transformation and how many are there in informatica?
What are the different lookup cache(s)?
where to store informatica rejected data?
What is the difference between router and filter?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What are the transformations that are not supported in mapplet?
