Answer Posted / 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 View All Answers
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Explain what are the different types of transformation available in informatica.
What is the difference between a repository server and a powerhouse?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
How are indexes created after completing the load process?
Why do we need informatica?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is mapplet in informatica?
what is size of u r database?
How many number of sessions can one group in batches?
On which transformations you created partitions in your project?
What do you understand by term role-playing dimension?
To import the flat file definition into the designer where should the flat file be placed?
What is pmcmd command?
