Interested to Buy Any Domain ? << Click Here >> for more details...
Difference Between ETL & ELT?
- 1 Answers
- 7797 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 |
If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?
what is correlated query?
how to delete duplicate records by using filter transfermation?
what is difference between mapping and mapplet ?
Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle
tell me 5 session failure in real time how can you solve that in your project?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com
get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c
i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z
What is a design?
Teradata 
