Interested to Buy Any Domain ? << Click Here >> for more details...
In dimension and fact table? which one holds big data?
- 2 Answers
- 6304 Views
- I also Faced
- E-Mail Answers
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 |
what is filelist concept in informatica
can we use cartesian join in informatica
Different circumstance which drives informatica server to expel records?
What is Index Caches size?
What is persistent lookup cache?
What is the cumulative sum and moving sum?
how to join two flat file if they have diff. structure?how to join one relational and one flat file?
Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio
What are partitions in informatica and which one is used for better performance?
Which gives the more performance when compare to fixed width and delimited file ? and why?
What is confirmed dimension and fact?
If there are more than one sessions running parallel in a worklet, which will be the last session ?
Teradata 
