Answer Posted / gopi
fact table without any fact or measures is known as
factless fact schema
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain do we need an etl tool?
How many steps etl contains explain with example?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
What are the steps involved in etl process?
how to load the data to fact table?
how do use session mapping parameters ?(in which transformation)
State the differences between shortcut and reusable transformation
what is pmrep command?
what are the cubes developed in a sap bw project and what is the requirement for developing it?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
What is partitioning? Explain different types of partitioning?
what do u do when DB time takes more?in sap bi
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
what is the main role of FI on business
what is the use of server?