How many steps etl contains explain with example?
- 1 Answers
- 1075 Views
- I also Faced
- E-Mail Answers
Answer / Laxmi
ETL typically consists of three main stages:
1. Extract: This involves pulling data from various sources like databases, files, or APIs.nExample: Extracting sales data from a database.
2. Transform: In this stage, the extracted data is cleaned and transformed to fit the target schema.nExample: Removing duplicate records or converting data types.
3. Load: The transformed data is loaded into the target database or data warehouse.nExample: Inserting the cleaned sales data into a data warehouse.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is HISTOGRAM? how to generate statistics?
you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.
if i have a query as flat file how can we load data to target table
What are the differences between sql override and update override?
If you concatenate data from a normalizer transformation,the ports you concatenate cannot include OCCURS(T/F).
How to know informatica conslole password??
Identifying the bottlenecks in various components of Informatica and resolving them.
flat filevalidation in informatica
Explain about power designer data modeling software?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
Explain about etl data integration software?
what are the facilities provided by data warehouse to analytical users?
Teradata 
