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 the Default Source Option For Update Strategy Transformation?
What is rank transformation in informatica
What is the scenario which compels informatica server to reject files?
What is data movement mode in Informatica and difference between them?
During the running session, output files are created by informatica server. Enlist few of them.
What is the function of look up transformation?
Implementation methodology
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What is the difference between writing a joiner query in ANSI style and THETA style?
How will the document be delivered to me?
Write the unconnected lookup syntax and how to return more than one column.
What can we do to improve the performance of informatica aggregator transformation?
Explain lookup transformation source types in informatica
What are the modules in Power Center
What are the tasks that source qualifier perform?