Interested to Buy Any Domain ? << Click Here >> for more details...
In dimension and fact table? which one holds big data?
- 2 Answers
- 6360 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 are the components of Informatica? And what is the purpose of each?
Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep
What is the need of etl tools?
What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?
What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance
source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What are the different threads in DTM process?
Performance tuning( what you did in performance tuning)
what is $$$$?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?
Teradata 
