What are the modules in Power Mart?
No Answer is Posted For this Question
Be the First to Post Answer
Two default user groups created in the repository are____and_____.
Two different admin users created for repository are________and_________.
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?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
in sap bw project at what scenario generic extraction is used and why explain and also tell why you used calendar day option explain?
What is etl tool in hadoop?
what are Lookup caches options? Including persistent caches.
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
What are three tier systems in etl?
How many steps etl contains?
what is the difference between cardinality and Nullability?