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
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is the difference between STOP and ABORT options in Workflow Monitor?
What are the measure objects?
Where are the source flat files kept before running the session?
What is intricate mapping?
How is union transformation utilized?
How to generate or load values in to the target table based on a column value using informatica etl tool.
How can you increase the performance in joiner transformation?
What is an active transformation?
Mention some types of transformation?
How can you differentiate between powercenter and power map?
Explain sessions?
what is mean by complex business rule ?
How to create the source and target database connections in server manager?
Enlist some properties of sessions.