Interested to Buy Any Domain ? << Click Here >> for more details...
Difference Between ETL & ELT?
- 1 Answers
- 7790 Views
- TCS, I also Faced
- E-Mail Answers
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 |
Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?
what are types of dimentions?
What are the connected or unconnected transforamations?
What is informatica?
Do you have to change the reject file b4 using reject loader utility.
What are the different ways to implement parallel processing in informatica?
How to fix the etl bugs..Tell me the process?
I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?
my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?
What are the features of complex mapping?
what is the gap analysis?
what is data driven?
Teradata 
