Interested to Buy Any Domain ? << Click Here >> for more details...
What are active transformation / passive transformations?
- 1 Answers
- 30 Views
- I also Faced
- E-Mail Answers
Answer / Ashwani Pandey
{"active transformations": "Active transformations in ETL are transformations that require real-time processing of data. They often involve complex calculations, conditional logic, or lookups to other tables. Active transformations can affect the performance of ETL jobs and should be used sparingly.","passive transformations": "Passive transformations, on the other hand, are simpler operations that do not require real-time processing. They include tasks like filtering, sorting, or aggregating data. Passive transformations are typically faster and more efficient than active transformations."
| Is This Answer Correct ? | 0 Yes | 0 No |
Techniques of error handling - ignore, rejecting bad records to a flat file, loading the records and reviewing them (default values)?
What are parameter files? Where do we use them?
What are the various tools? - Name a few?
How to determine what records to extract?
When do you analyze the tables?
How do you analyze the tables
What are snapshots? What are materialized views & where do we use them? What is a materialized view?
What are materialized views & where do we use them? What is a materialized view?
Where do we use connected and un connected lookups?
What is the purpose of a staging area?
What are active transformation / passive transformations?
Can we look-up a table from source qualifier transformation. Ie. Unconnected lookup?
Oracle General 
