Difference Between ETL & ELT?



Difference Between ETL & ELT?..

Answer / kunkala.ramakrishna

ETL:- ETL MEANS FIRST EXTRACT DATA FROM SOURCES AND TRANSFORMS DATA FOR DESIGNED FORMAT THEN LOAD THE DATA IN TO TARGET

IN THIS ETL THE DATA MOVING 2 TIME IN THE NETWORK
1 SOURCE TO STAGGING
2 STAGGING TO TARGET

ELT: ELT MEANS FIRST EXTRACT THE DATA FROM SOURCES AND LOAD IN TO TARGET THEN TRANSFORM DATA FOR DESIGNED FORMAT

HERE DATA FIRST LOAD IN TEMPERY TABLES AFTER TRANSFORM THE DATA THEN LOAD IN TO PERMENT TABLES

IN THIS ELT THE DATA MOVING 1 TIME IN THE NETWORK

Is This Answer Correct ?    3 Yes 2 No

Post New Answer

More Informatica Interview Questions

Name the different lookup cache(s)?

0 Answers  


write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

5 Answers  


tell me the push down optimization

2 Answers   Wipro,


Explain joiner transformation in informatica

0 Answers   Informatica,


how lookup is acting as both active and passive ? how is it possitble?

9 Answers   TCS,






what is threshold error in informatica?

1 Answers   TCS, Wipro,


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

0 Answers  


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

0 Answers  


What are the ETL tools available in DWH?

6 Answers   Mphasis,


What are slowly changing dimensions?

5 Answers   Informatica, Verinon Technology Solutions,


What is difference between maplet and reusable transformation?

2 Answers  


How to load query faster,so that It will take less time to load?

1 Answers   BNP Paribas,


Categories