Search results for query: *

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...

Thank you. This solution worked. Used Lead function to get the difference.

Hi Thank you for your suggestion. I appreciate your time for this forum. So basically I have to create two views one with sequence no for each row. The other view will be a sequence + 1 from same table. Then join the two views by customer id, sequence no and get the difference of effective...

Thanking you for your suggestion. But if status changes from 1--> 2 2--> 3 3--> 1 1--> 3 1--> 2 we have data like customer_id status_id, eff_dt_tm Active_flag 1 1 20110603112325 N 1 2 20110604112325 N 1 3...

Hi Since I am designing a Fact table and it will be factless fact table. Above after this fact I will create an View or MV over this fact table which will calculate the difference and store the differences by hours for each status. But not able to decide how will I design if status goes...

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...