Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Implement OLAP Lead Function in Informatica
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...- dmishra
- Thread
- Replies: 1
- Forum: Data Warehousing/Big Data
-
Accumulated Fact design when status can go either direction
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...- dmishra
- Thread
- Replies: 9
- Forum: Data Warehousing/Big Data
