On a day, I load 10 rows in my target and on next day if I
get 10 more rows to be added to my target out of which 5 are
updated rows how can I send them to target? How can I insert
and update the record?
- 6 Answers
- 11603 Views
- I also Faced
- E-Mail Answers
Answer Posted / sid
take a look t/f and a update strategy t/f. basing on look
up , if the record exits in target then reject it ,if not
exit insert it,and if the record exist but it is changed
then update it
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is different between the data warehouse and data mart?
Difference between Target-based loading and constraint-based loading?
How do you load only null records into target?
What is lookup change?
What is main use of mapplet?
In how many ways we can create ports?
How might you approve all mappings in the archive all the while?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is the benefit of partitioning a session?
Explain joiner transformation in informatica
How are indexes created after completing the load process?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Write the different tools in the workflow manager?
What is rank transformation in informatica
How is union transformation utilized?
