working of line item dimension......pls,tell overall flow
Answer / rupali khare
Line item dimension is a dimension,which is deriver from the
fact table and doesn't have it's own dimension table.ie.
degenerated dimension called line item dimension.
| Is This Answer Correct ? | 0 Yes | 0 No |
how do u implement unconn.stored proc. in a mapping?
what is the difference between OLTP database and data warehousing database?
Explain about power designer data modeling software?
what is the meant by Normalization and de-normalization?
what are Lookup caches options? Including persistent caches.
When do we analyze the tables?
what are the concerns of OLTP and DSS systems?
What is a mapping, session, worklet, workflow, mapplet?
What is Data Vault???
State the differences between shortcut and reusable transformation
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
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.