Interested to Buy Any Domain ? << Click Here >> for more details...
in mapping i have one source and five targets in that data
will be loaded into four targets properily
in one target the data is not loaded how will u rectify
- 3 Answers
- 7406 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / naresh
Check the run properties in session logs()workflow
monitor), that how many records are loaded in each target
adn use contrain-based loading will be work out.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
tell me about your project functionality
What is enterprise data warehousing?
What are multi-group transformations?
What is mapplet in informatica?
Define pmcmd command?
Quickly characterize reusable change?
r u done any partitions in ur project?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is meant by target load plan?
If informatica has its scheduler why using third party scheduler?
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 reusable transformation?
explain one complex mapping with logic? sales project?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is the sequence generator transformation in informatica?
