Answer Posted / gp
The table contain measurable data(facts) is called fact
table .
These facts defined three types : Additive
Non Additive
Semi additive facts
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How can we improve session performance in aggregator transformation?
What are the issues you have faced in your project? How did you overcome those issues?
What is a snowflake schema?
What is session task and command task?
lookup transformation with screenshots
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is lookup change?
What is expression transformation?
Whats there in global repository
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is informatica etl tool?
What do you mean by enterprise data warehousing?
Explain dynamic target flat file name generation in informatica
How to elaborate powercenter integration service?
What is the difference between source qualifier transformations source filter to filter transformation?