time to load 40 Million records
Could you please provide the information how much time it takes to load data from ODS1 to ODS2.
ODS1 Contains 40 million records which has a look up on ODS2. Its small look up not complex coding involved. How much time approximatly it takes.
2. One more thing Infoset has built on the top of two ODS's and it has huge data volume. Let us say around 25 to 26 Million records are exists. How much it takes query which is built on this InfoSet.
thank you very much for your valuable answers and ideas.