Interested to Buy Any Domain ? << Click Here >> for more details...
If there are more than one sessions running parallel in a
worklet, which will be the last session ?
- 2 Answers
- 7326 Views
- I also Faced
- E-Mail Answers
Answer Posted / vasu
In Worklet/workflow if all the seesions running on
parallel way there is no dedpendency on each other.
Irrespective of Performence tune,
Mapping logic,sql & lookup query & Wf settings..
Which session processing the huge volume of data that will
the last session.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Define the various join types of joiner transformation?
What is the difference between informatics 7x and 8x and what is latest version?
Is it possible to create multiple domains on a single Informatica server?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Slowly changing dimensions, types and where will you use them
Difference between Data and Index Caches?
What is workflow manager?
Explain dynamic target flat file name generation in informatica
How can we remove the duplicates from flat file source?
What is Data Caches size?
What is meant by query override?
What is the format of informatica objects in a repository?
What is different between the data warehouse and data mart?
What is option by which we can run all the sessions in a batch simultaneously?
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
