Interested to Buy Any Domain ? << Click Here >> for more details...
What is workflow variable? When we use workflow variable? Can any one explain me with one example???
- 2 Answers
- 18215 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / guest
I used workflow variable to update the session status in
database table.
take assignment task for capturing session status by using
workflow variable if you want in depth pls let me know..
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How to go to the older version for a mapping?
Explain joiner transformation in informatica
What are the different ways to implement parallel processing in informatica?
What is meant by pre and post session shell command?
What are session parameters ? How do you set them?
What is event and what are the tasks related to it?
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 do you mean by blocking transformation?
What are the popular informatica products?
How you can differentiate between connected lookup and unconnected lookup?
Implementation methodology
Could you explain what is enterprise data warehouse?
Differentiate between a repository server and a powerhouse?
