How to load dimension and fact in same mapping at same
time.explain me the logic used for that scenario.

Answer Posted / isha

We can use contraint based loading in that case and after loading all the dimensions table we can load the data into fact table.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define enterprise data warehousing?

636


tell me 5 session failure in real time how can you solve that in your project?

1634


How are indexes created after completing the load process?

989


What's the layout of parameter file (what does a parameter file contain?)?

1918


Whats the difference between informatica powercenter server, repositoryserver and repository?

680






What all are steps in up gradation of Informatica server?

624


What is mapping debugger?

574


What are the prerequisite tasks to achieve the session partition?

716


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1055


How do you set a varible in incremental aggregation

1451


How to generate sequence numbers without using the sequence generator transformation?

649


Enlist few areas or real-time situations where informatica is required.

597


What is informatica worklet?

613


What do mean by local and global repository?

707


How might one distinguish in the case of mapping is right or not without associating session?

642