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.
No Answer is Posted For this Question
Be the First to Post Answer
Explain about etl data integration software?
what is the difference between date cache and lindex cache?
what is meant by drill through?(Mascot)
What are the three tiers in etl?
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
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)
what are Lookup caches options? Including persistent caches.
Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
What exact we can see in table?
what are the different Reporting and ETL tools available in the market?
what is the use of structures?how many nodes can u create in a structure?