A mapping contains
(1) Source Table S_Time ( Start_Year, End_Year )
(2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
Answer / pati
Day = to_char(sysdate,'Day')
Date = to_char(sysdate,'DD')
Month = to_char(sysdate,'Month')
Year = to_char(sysdate,'YYYY')
Quater = to_char(sysdate,'Q')
Is This Answer Correct ? | 3 Yes | 2 No |
what is diff b/t sorter t/r and agg have the option sorter property...
Define Incremental Aggregation?
can u give example for factless fact table
why we use datawarehouse
Briefly define reusable transformation?
What is deployemnt groups, Lables, query and dynamic deployment group.
Explain grouped cross tab?
when we go for unconnected lookup transformation? and why?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is joiner transformation in informatica?
How does the aggregator transformation handle null values?
Does Facttable Normalized or Denormalized?