Interested to Buy Any Domain ? << Click Here >> for more details...
Which is better performance wise database or file?How?
- 2 Answers
- 6617 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
files are better in performance than database.
because database has to connect to the odbc,and some drivers to extract or load the data.
But in case of file we directly extract or load the data.so,as per the performance files are better
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / gyana
flat files are good for performance....
but fixed width files are more better than a delimited flat file......
| Is This Answer Correct ? | 2 Yes | 0 No |
My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...
what is curr val use for in sequence generator?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
what are cost based and rule based approaches and what is the difference?
What is predefined event?
What is Code Page Compatibility?
can session assigned multiple mappings or not?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
how many ways can we implement SCD2?
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
what is fact table?
Teradata 
