Which kind of index is preferred in DWH?

Answer Posted / pushparao

bitmap index

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain incremental aggregation in informatica

660


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

1941


Mention few power centre client applications with their basic purpose?

539


What is the meaning of decode in informatica?

650


Why do you use Mapping Parameter and mapping variable?

1288






I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1473


What are active and passive transformations?

654


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

702


What is joiner transformation?

585


write a query to retrieve the latest records from the table sorted by version(scd)

635


How to convert multiple rows to single row (multiple columns) in informatica

900


Describe the impact of several join conditions and join order in a joiner transformation?

649


Did u used latest transformations of 8.6.0? for what?

1481


How do you load unique records into one target table and duplicate records into a different target table?

712


What is the way to execute pl/sql script using informatica mapping?

966