How many number of sessions that u can create in a batch?
Answer Posted / swetha
Any number of sessions.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is target load order?
How do you migrate data from one environment to another?
Plz can any one say me how to get the informatica certification materials and dumps
What does update strategy mean, and what are the different option of it?
Difference between Target-based loading and constraint-based loading?
What are the mapping parameters and mapping variables?
Implementation methodology
What do think which one is the better joiner or look up?
draw informatica architecture 8.6 ?
What are the types of caches in lookup?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
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
How can we remove the duplicates from flat file source?
Mention few advantages of router transformation over filter transformation.
Briefly describe lookup transformation?