how will u load the data to diminision tables and fact
tables,what is the hiraraichy why we are using hirarichy
- 2 Answers
- 6434 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / gm
You load dimension table before loading fact table. But
using Dynamic Lookup, you can load both simultaneously.
======
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Mention some types of transformation?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
what are the Methods For Creating Reusable Transformations?
What is confirmed fact in dataware housing?
What are the steps involved in the migration from older version to newer version of Informatica Server?
How to join three sources using joiner?
What are the different clients of powercenter?
Explain the difference between a data warehouse and a data mart?
Describe an informatica powercenter?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Explain about cumulative Sum or moving sum?
How many ways are there to create ports?
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?
