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
- 7809 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 |
As union transformation gives UNION ALL output, how you will get the UNION output?
Why we need XMLs?
What is the difference between OLTP and ODS?
What is meant by target load plan?
My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.
can v update d records in target using update stargey without generationg primary key ? explain
Consider a Phone Log table as below. It records all phone numbers that we dial in a given day. SOURCE_PHONE_NUMBER DESTINATION_PHONE_NUMBER CALL_START_DATETIME 1234 4567 01/07/2011 10:00 1234 2345 01/07/2011 11:00 1234 3456 01/07/2011 12:00 1234 3456 01/07/2011 13:00 1234 4567 01/07/2011 15:00 1222 7890 01/07/2011 10:00 1222 7680 01/07/2011 12:00 1222 2345 01/07/2011 13:00 Please provide an SQL query to display the source_phone_number and a flag where the flag needs to be set to Y if first called number and last called number are the same and N if the first called number and last called number are different. Desired Output: Source Number Is_Match 1222 N 1234 Y
WHat all joins are there in Source Qualifier?
What is power center repository?
What are conformed dimensions?
when we create source as oracle and target as flat file, how can i specify first row as column in flat file?
Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?
Teradata 
