let startDate = new Date(); let elapsedTime = 0; const focus = function() { startDate = new Date(); }; const blur = function() { const endDate = new Date(); const spentTime = endDate.getTime() - startDate.getTime(); elapsedTime += spentTime; }; const beforeunload = function() { const endDate = new Date(); const spentTime = endDate.getTime() - startDate.getTime(); elapsedTime += spentTime; // elapsedTime contains the time spent on page in milliseconds }; window.addEventListener('focus', focus); window.addEventListener('blur', blur); window.addEventListener('beforeunload', beforeunload);
top of page
Search

Informatica Scenarios

Once you install PowerCenter on your system the question which starts thumping your brain is how to get started in this post I have attached some sample Informatica transformations. The said transformations also contain an import file that can be easily imported through the repository manager of the designer tool.


Converting Rows to Column




EVERY NTH ROW



Insert Records In Cyclic Orders


Seperating Duplicate And Non-Duplicate Rows




SPLITTING TABLES (NON KEY COLUMNS TO DIFFERENT TABLES)




SCD_TYPE1


Will Upload some more samples in the next post.





 
 
 

Comments

Post: Blog2_Post
  • LinkedIn
  • Facebook
bottom of page