Interested to Buy Any Domain ? << Click Here >> for more details...
Does Facttable Normalized or Denormalized?
- 2 Answers
- 8169 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Fact tables are normalized. Dimension tables are denormalized
| Is This Answer Correct ? | 27 Yes | 0 No |
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?
how can u approach u r client
My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.
How many number of sessions can one group in batches?
Enlist the tasks for which source qualifier transformation is used.
How many types of sessions are there in informatica.please explain them?
How many ways you create ports?
What are the types of lookup?
I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?
What is polling in informatica ?
How many input parameters can exist in an unconnected lookup?
Teradata 
