Interested to Buy Any Domain ? << Click Here >> for more details...
on a day i load 10 rows in my target and on nextday i get
10 more rows add to my target but out of 5 are update row
how ican send them to target?how i can insert and update
the records
- 4 Answers
- 8745 Views
- Fidelity, I also Faced
- E-Mail Answers
Answer Posted / arpit
For this a SCD type2 mapping has to be created which will handle both update and insert. This mapping will be having 2 target instances i.e. one instance for updating and other is for inserting records. Use router to divide the rows in two groups i.e. update and insert. In the pipeline for update target instance use the update strategy transformation for update.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the maplet?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What are the new features of informatica 9.x at the developer level?
What are some examples of informatica etl programs?
Explain sessions. Explain how batches are used to combine executions?
What is Cognos script editor?
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?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
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
list out all the transformations which use cache?
what is SDLC way of code development?
What is a sorter transformation?
How many types of sessions are there in informatica.please explain them?
difference between repository database and repository service?
Can anyone tell me the new features in Informatica 9 Version?
