Hi, This is Ranadheer. How to load fact tables using
dimeension tables. Please anyone give me a answer with
example. Thanks in Advance.
Answer / rao
Firstly we have to load the dimension tables.from dimension
tables take the primary key reference and load the Fact table.
That mean if you have dimensions like product,branch,customer,
we load product id,branch id,customer id(only surrogate keys)
to fact table .later measure will be loaded.
Is This Answer Correct ? | 0 Yes | 1 No |
What are the uses of a Parameter file?
What do think which one is the better joiner or look up?
Explian the connected and unconnected lookup transformation
What is the method of seperating unique and duplicate records in session level?
2 Answers Emphasis, JBL, Wipro,
Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?
wat are deployement groups in informatica, how it will be used for developers
Why we use partitioning the session in informatica?
what is datamart
Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.
How can i send first half of the records to one target and Remaining to other target?
What is the meaning of decode in informatica?
How to partition the Session?