Interested to Buy Any Domain ? << Click Here >> for more details...
I have a scenario with lookup table. in that lookup table have
colomns, but i need to process only 10 colomns out of 50.
Please te me how can we acheive it?
- 6 Answers
- 10820 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / srinivasarao
we can use look up over ride
| Is This Answer Correct ? | 0 Yes | 5 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
where to store informatica rejected data? How to extract the informatica rejected data?
What do you understand by a term domain?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What is intricate mapping?
Explain what are the different types of transformation available in informatica.
What are the types of caches in lookup?
What is status code in informatica?
what is the complex transformation you used in informatica
What are the new features of informatica 9.x developer?
What are the main issues while working with flat files as source and as targets ?
Define mapping and session?
How can repository reports be accessed without sql or other transformations?
Mention few advantages of router transformation over filter transformation.
What are the guidelines to be followed while using union transformation?
