Hi
I want to implement OLAP Lead function in informatica mapping without taking intermediate tables.
Here is the example of requirement.
SOURCE TABLE
ID STATUS FROM_DATE
1 A 20110201
1 B 20110303
1 C 20110306
1 B 20110402
2 A...
Hi
I have to design a fact table to find the duration for each state.
I have the following states available from source for a customer
draft
intial
open
review
purchase
close
cancel
So I have designed a fact table with following columns
customer_ik,draft_date_time_key...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.