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
Under what conditions selecting sorted input in aggregator will still not boost session performance?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Explain the features of connected and unconnected lookup.
What are the popular informatica products?
What is workflow? What are the components of the workflow manager?
What is aggregator transformation in informatica?
How do you take back up of repository?
What are the different ways to implement parallel processing in informatica?
Tell me about MD5 functions in informatica
What are the different lookup cache(s)?
have u done any performance tuning? how u ll do?
What is sq transformation?
Explain dynamic target flat file name generation in informatica
What is the way to execute pl/sql script using informatica mapping?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
