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 is meant by a domain?
differences between service based and product based?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is a mapplet/worklet in informatica?
What is flashback table ? Advance thanks
How do we call shell scripts from informatica?
On which transformations you created partitions in your project?
How can a transformation be made reusable?
How might one distinguish in the case of mapping is right or not without associating session?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How to Create a folder using pmrep command?
Can informatica load heterogeneous targets from heterogeneous sources?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
How can we update a record in the target table without using update strategy?
What are the differences between oltp and olap?