what is the logic will you implement to laod the data in to
one factv from 'n' number of dimension?
Answer Posted / sridhar
if u using star schema to u have to develop the dim tables depends on requirement(like scd1,2,3) then u have to look up on all dim tables using natural keys,when the session time u have to load dim's are sequence process like (s1-s2-s3-s4--eventraise)then all success u can load fact load by using eventwait in concurent manner.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is enterprise data warehousing?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What is the sql query overwrite in source qualifier in informatica
Mention few power centre client applications with their basic purpose?
Tell me about Propagate functions in informatica
if we have a delimiters at unwanted places in a flat file how can we over come those.
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Which transformation should we use to normalise the COBOL and relational sources?
what is Active lock explain
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Under what condition selecting sorted input in aggregator may fail the session?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
COM components can be used in Informatica