In dimension and fact table? which one holds big data?
Answers were Sorted based on User's Feedback
Answer / ravikumar2614
Fact table having huge data with less colomns..
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / davankumar
Fact table has the big data bcoz fact table main tain
history data.
| Is This Answer Correct ? | 2 Yes | 1 No |
Hi 2 every one. i dont have real time experience, and please suggest me for following questions. a) we get the source data from what type of source systems? b) In banking domain project what are the FACT & DIMENTION tables please list out them? c) please write some colomn names in a table? Please reply for aboue questions?..... Thanks in advance.
How do you update the records with or without using update strategy?
How can u insert o ne row in the target if that row does not exists in the target and update if it exists
hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com
What is a mapplet/worklet in informatica?
Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.
Tell me about Propagate functions in informatica
if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.
Explain pmcmd command usage in informatica
How do you create single lookup transformation using multiple tables?
By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?
write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste