Interested to Buy Any Domain ? << Click Here >> for more details...
i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?
- 1 Answers
- 4955 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / harish konda
1. Declare workflow and mapping variables and assign them in Pre and Post session.
2. Use Transaction control transformation to create the target files dynamically.
Like everytime you run the session you can create the target file with the value of mapping variable as a run number.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Explain direct and indirect flat file loading (source file type) - informatica
what is unit testing?tell me proceedure
Where do we use mapping variables in informatica?
What is a filter transformation?
What is meant by pre and post session shell command?
Describe the impact of several join conditions and join order in a joiner transformation?
What are the databases that informatica can connect to windows?
Where is metadata stored?
What are the different options available for update strategy?
What is the function of look up transformation?
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 is the Process to creating lookup transformation in informatica
How can one identify whether mapping is correct or not without connecting session?
What is target load order?
