| |
GeekInterview.com > Interview Questions > Data Warehousing > ETL
| Print | |
Question: In What scenario ETL coding is preferred than Database level SQL, PL/SQL coding?
What is the methodology and process followed for ETL testing in Data warehouse environment?
Develop a mapping to extract the employee drawing maximum salary where deptno = department drawing...
If LKP on target table is taken, can we update the rows without update strategy transformation?
How you capture changes in data if the source system does not have option of storing date/time field...
What is the Difference between a ODS and Staging Area
What is the effect of the OPTIONS statement ERRORS=1
What are push and pull
ETL strategies?
How do you tell aggregator stage that input data is already sorted
Can anyone please explain why and where do we exactly use the lookup transformations.
Thanks in advance
Thanks
Nayana...
|
| June 06, 2009 16:22:35 |
#2 |
| SQLGal |
Member Since: October 2008 Total Comments: 6 |
RE: In What scenario ETL coding is preferred than Database level SQL, PL/SQL coding? What is the methodology and process followed for ETL testing in Data warehouse environment? Develop a mapping to extract the employee drawing maximum salary where deptno
|
The simple answer is, when it is cost effective. ETL tools save time but can be expensive. They are more efficient than writing code because the code is built using drag and drop. These code files are organized into mappings or packages. (Code rarely has to be written and code errors are managed and fixed in the debugger). The ETL objects can be nested, shared and reused. They can be manipulated and executed using control structures.
Use the lookup transformation for scalability. If you have a where clause that looks (for example) three cities - Los Angeles, Phoenix and Dallas. Put those values in a table and use the lookup transformation. Then, if the list of cities changes, you won't have to modify the transformation. |
| |
Back To Question | |
