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
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
how to load rows into fact table in data warehouse
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?
What is rank index in rank transformation?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How to extract the informatica rejected data?
As union transformation gives UNION ALL output, how you will get the UNION output?
How to use pmcmd utility command?
Can informatica load heterogeneous targets from heterogeneous sources?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How to call shell scripts from informatica?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Explain the features of connected and unconnected lookup.
How can you define user defied event?
how to load dimension table and fact table. plz tell me the steps.
