Question
How do you do incremental load?
Answers
Fastest way to do incremental load is by using Timestamp column in source table and then storing last ETL timestamp, In ETL process pick all the rows having Timestamp greater than the stored Timestamp so as to pick only new and updated records.   Your Comment




  • Contributors: *,
More Software Questions..
What is the inputsplit in map reduce software?
What is software configuration management?
What Is Java Api For Xml-based Rpc (jax-rpc)?
How can you implement fine-grained auditing?
What is IBM’s simple explanation for Big Data’s four critical features?
What is static synchronized method in JDBC API? Give an example?
What does the NULLIF function do?
What happens if a start method is not invoked and the run method is directly invoked?
Should we override finalize method
what is the difference between mysql_fetch_array and mysql_fetch_object?
How will XML affect my document links?
Why to use Style Sheets?
What are Filters in MVC?
Can you explain Application layer in OSI model?
How to define new testplan attributes?
What are the minimum system requirements to run Photoshop? Is it possible to run Photoshop over linux?
Which oracle package is used to manage the oracle lock management services?
What is Latch Up? Explain Latch Up with cross section of a CMOS Inverter. How do you avoid Latch Up?
What is marker interface?
What types of partitioning are there for BW?


Search
Can you Answer!!
  • Q How to move the list from one site to another site?
  • Q What are dynamic actions? give a few examples. What are the it's you used in them. (i know only birth of child action, and the it's used in it are personal data, additional payments)
  • Q Is responsible for hearing evidence and determining whether probable cause exists, allowing the accused to continue to be held for trail? (A)District Attorney (B)Jury (C)Grand Jury (D)Prosecutor
  • Q When you disagree with your supervisor, how do you handle it?
  • Q Vitamin A has a protective effect against malignancy because crystalline vitamin A has a toxic effect on tumor cells.
  • Q On what date Indo.US Nuclear cooperation treaty was signed?
  • Q Who is the chairman of National Security Council of North Korea?
  • Q For instanent energy, which is following given is athletes:–
  • Q What is Jagged Array in VB.NET
  • Q Salinity of sea water refers to the salt content expressed in terms of gram per kilograms. The average salt content is :
  • Q Why C is known as a mother language