Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / venkat
If all dimention tables are succeded then only you can load
data in to the facts.if any one of the dimention is not
filled you cannot load data into the fact tables.Fact table
size can be calculated based on the lowest level
granularity of dimention tables.
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
how many types of dimensions are available in informatica?
Please let me know how to make encryption and decryption with example?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is data movement mode in Informatica and difference between them?
What is a transaction control transformation?
How do you handle two sessions in Informatica
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
can u any challenge your project?
How do you load first and last records into target table?
Can we create a Integration service without a Repository service and vice versa?
What is depict expression change?
Where is metadata stored?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
How to configure mapping in informatica?
What is a filter transformation?
