Worth time spending Informatica scenarios. Catch @ below link.

Comments

Post a Comment

Popular posts from this blog

Using DEFAULT clause for populating Surrogate Keys

In Oracle Database 12 c , a suite of improvements has been implemented around the DEFAULT clause for table columns. A sequence value can now be assigned as the default value for a column. With one simple command, we can remove the need for triggers for populating Surrogate Keys. Creating a DB Trigger: SQL> create or replace   2  trigger TRG_SALES_SURROGATE_KEY   3  before insert on SALES   4  for each row   5  begin   6    :new.SALE_SEQ := SEQ_SALES.nextval;   7  end;   8  /   Trigger created.   Inserting 10 million rows for testing the Insert time.   SQL> insert /*+ APPEND */ into SALES   2  select rownum, ...   3  from   4   ( select 1 from dual connect by level <= 10000 ),   5   ( select 1 from dual connect by level <= 1000 )   6  /   10000000 rows created.   Elapsed: 00:06:3...
Read more

Time Series Decomposition

Image
A time series decomposition is a mathematical procedure which transform a original time series into 3 sub-time series. Seasonal: Patterns which repeat with fixed period of time. User page visits to a website increases in the weekends, so a seasonality of 7 days is observed. Trend: Underlying trend of metrics like User page visit count. Random: Residual of time series after allocation into seasonal and trends time series. There are two types of decomposition: Additive and Multiplicative. They have to be chosen correctly for successful decomposition. Additive: The magnitude of seasonality remains constant when time series increases. Time series = Seasonal + Trend + Random Multiplicative: The magnitude of seasonality varies constantly with time series. Time series = Trend * Seasonal *Random
Read more