Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ghouse
to load the data into the fact table b tree index is created
and bit is used where the cordinality of the coloumn is very
low i.e(in dwh-denormalised one)(OLAP)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Write the different tools in the workflow manager?
Can we override a native sql query within informatica?
What are session parameters ? How do you set them?
What do you understand by SOA of Informatica?
Name the different lookup cache(s)?
How are indexes created after completing the load process?
What is update strategy transform?
Explain what is informatica metadata and where is it stored?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Clarify the aggregator change?
What is a filter transformation and why it is an active one?
How many ways a relational source definition can be updated and what are they?
Do you find any difficulty while working with flat files as source and target?
What are the uses of etl tools?
What is the scenario which compels informatica server to reject files?
