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
- 8744 Views
- Fidelity, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the need of etl tools?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Enterprise data warehouse your projects phase by phase explain?
How can one identify whether mapping is correct or not without connecting session?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Enlist the tasks for which source qualifier transformation is used.
Why do we need informatica?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What are the main issues while working with flat files as source and as targets ?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What are multi-group transformations?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What are active and passive transformations?
