Difference Between ETL & ELT?
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 |
In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?
Under what condition selecting sorted input in aggregator may fail the session?
Explain in detail scd type 2 through mapping.
Explain the aggregator transformation?
How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?
What all are steps in up gradation of Informatica server?
What are the reusable transformations?
Explain informatica architecture - version 8 / 9
If u r using dynamic cache lookup port will be thier in thet which option u will select
What is a code page?
yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?
How IN function works in informatica? Is it similar that of oracle IN function or different? Explain