Can any one give me a real time example for FACT TABLE &
DIMENSIONAL TABLE?
Answer Posted / boopalan venugopal
THANKU SO MUCH Jaspreet, U have given a gr8 example, which always be in my mind....thanks again..
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the difference between a connected look up and unconnected lookup?
in reporting we add some new objects,how we get the count of the newly added objects to the report
Explain the shared cache and re-cache?
Explain the use of aggregator cache file?
Differentiate between sessions and batches?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Explain the tuning lookup transformation - informatica
What differs when we choose the sorted input for aggregator transformation?
What is a connected transformation?
What do you mean by filter transformation?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?