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
- 8472 Views
- Fidelity, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajendra kommineni
WE CAN USE SCD TYPE1
i.e BY USING UPDATE STATERGY
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / 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 |
Answer / jaspreet banga
For This we Have to Use Job Control table(JCT), JCT is used
to select only those records which are provided next day
and then in mapping :---
1.) In source Qualifier write a pre sql query to read only
those record which are provided previous day, ]
2.)In router Route the data for update and insert.
3.) Use 2 update strategies i.e.., one for updating
existing record and other for inserting new one.
(Type-1 SCD) if you dont want to preserve the history.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / abhinaw prakash
We can use Update strateGY TO execute the following scenario
| Is This Answer Correct ? | 0 Yes | 0 No |
Where do we use mapping variables in informatica?
i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?
Explain the types of transformations?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How can you join two tables without any common column present in them?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
wat s mapping parameter and mapping variable? how do you set that in a mapping?
Are there any types of Dynamic Caches in informatica
What is data merging,data cleansing,sampling?
select count(1) from emp? what is the o/p?
Explain about cumulative Sum or moving sum?
Teradata 
