Difference Between ETL & ELT?
- 1 Answers
- 7275 Views
- TCS, I also Faced
- E-Mail Answers
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 |
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
what is degenerated dimension table with scenario
plz plz plz send client names and project names in informatica?
If we set dd_insert in mapping and Delete in session properties what will happen.?
Difference between Target-based loading and constraint-based loading?
There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??
Name 4 output files that informatica server creates during session running?
How can we get multiple output values using an unconnected lookup transformation?
sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it
what is casual dimension?
What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?
what is service oriented architecture in Informatica 8 version
1 Answers Cap Gemini, IBM, Systech, TCS,
Teradata 
