why dimenstion tables are denormalized in nature ?
Answers were Sorted based on User's Feedback
Answer / siddu
For fast retrieval(to Perform a SELECT Operation)
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / ankit kansal
As a denormalized table structures for a database the number
of joins to fetch the data turns out to be less and hence selection to the data becomes faster.
selecting data from one table is always better than selecting the same data from multiple tables.
http://deepinopensource.blogspot.in/
Is This Answer Correct ? | 1 Yes | 0 No |
My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.
How do you load only null records into target?
what is confirmed dimension?
what are the output files that the informatica server creats during running a session?
What is the use of source qualifier?
How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?
1 Answers Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,
where does the default group roew in a router is stored what is the default size of memory in router
How do you load first and last records into target table?
I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?
What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.
If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.