what is the logic will you implement to load data into a
fact table from n dimension tables?

Answer Posted / satyaranjan

Always load data from dimension to fact is incremental load

Is This Answer Correct ?    6 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell me about MD5 functions in informatica

605


explain about unit testing? in real time?

1782


What is an active transformation?

739


What is a repository? And how to add it in an informatica client?

773


Design time, run time. If you don't create parameter what will happen

1519






What is the cumulative sum and moving sum?

865


What is a pre-defined event and user-defined event?

669


What are the advantages of informatica?

662


is it possible to index the data in cache of lkp transformation ?

1624


In informatics server which files are created during the session rums?

731


Define pmcmd command?

714


Mention few advantages of router transformation over filter transformation.

738


What is the sql query overwrite in source qualifier in informatica

709


How big was your fact table

1409


How can one identify whether mapping is correct or not without connecting session?

1020