Full Load: completely erasing the contents of one or more tables and reloading with fresh data.
Incremental Load: applying ongoing changes to one or more tables based on a predefined schedule.
When addressing a table some dimension key must reflect the need for a record to get extracted. Mostly it will be from time dimension (e.g. date >= 1st of current mth) or a transaction flag (e.g. Order Invoiced Stat). Foolproof would be adding an archive flag to record which gets reset when record changes.
It is used to Extract(E) data from multiple source systems(like RDBMS,Flat files,Mainframes,SAP,XML etc) transform(T) them based on Business requirements and Load(L) in target locations.(like tables,files etc).
Need of ETL Tool:
An ETL tool is typically required when data scattered accross different systems.(like RDBMS,Flat files,Mainframes,SAP,XML etc).
Yes, you can use advanced external transformation. for more detail you can refer the manual of informatica transformation guide in that advance external transformation. You can use c++ language on unix and c++, vb vc++ on windows server.
Yes,we can override a native sql query in source qualifier and lookup transformation.
In lookup transformation we can find "Sql override" in lookup properties.by using this option we can do this.
Select appropriate Question to view its more answers in this category of
Do you find any Answer incorrect or incomplete? Please e-mail us or
place your comment and mention the number of question or if you have correct answer then
open the appropriate question by clicking on question and then place your answer in comment
regarding particular question in this category "Oracle Extract transform load (ETL) Interview Questions and Answers" To ensure quality,
each change is checked by our team, before it enters the main website
database. If you desire so, the changes will be credited to your name.