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 |
what are the row and column separations in Flat Files
What is sq transformation?
what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?
Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400
In update strategy target table or flat file which gives more performance ? why?
How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?
differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Two different admin users created for repository are ______ and_______
How many dimensions are there in informatica?
What are the circumstances that infromatica server results an unreciverable session?
disable caching in a lookup transformation?