infiniteandmore.blogspot.com
Information Storage and Retrieval: January 2014
http://infiniteandmore.blogspot.com/2014_01_01_archive.html
Enter your search terms. Information Storage and Retrieval. Saturday, January 25, 2014. Statistics is the science of collecting,organizing, summarizing, analyzing and interpreting data. Take numerical values whose "size" is meaningful. Quantitative. Variables answer questions such as "how many? Such as social security numbers and zip codes, take numerical values, but are not quantitative: They are qualitative. Variables usually does not make sense, even if the variables take numerical values. Categor...
infiniteandmore.blogspot.com
Information Storage and Retrieval: July 2013
http://infiniteandmore.blogspot.com/2013_07_01_archive.html
Enter your search terms. Information Storage and Retrieval. Wednesday, July 3, 2013. Asymptotic analysis of Algorithms. The complexity of an algorithm function is usually described as a function of the number of inputs it receives. Eg searching(linear search) a particular element in an array of n integers can be described as. F(n) = 4 2n. This method of removing all factors and of "keeping the largest growing term" as described above is what we call. In the limit of function f as. Big-Oh Notation: Its th...
infiniteandmore.blogspot.com
Information Storage and Retrieval: What is the difference between an Oracle User and an Oracle Schema?
http://infiniteandmore.blogspot.com/2014/01/what-is-difference-between-oracle-user.html
Enter your search terms. Information Storage and Retrieval. Sunday, January 19, 2014. What is the difference between an Oracle User and an Oracle Schema? An Oracle schema is a collection of database objects like tables, functions, indexes etc A user "owns" a schema. When a user is created, it is given access to a schema with same name. A user can be given access to objects of other schema. For all intents and purposes you can consider a user to be a schema and a schema to be a user. Cursor and Ref Cursor.
infiniteandmore.blogspot.com
Information Storage and Retrieval: June 2014
http://infiniteandmore.blogspot.com/2014_06_01_archive.html
Enter your search terms. Information Storage and Retrieval. Sunday, June 15, 2014. A way to design datawarehouse. It employs Ralph Kimball's bottom up approach to design data marts using conformed Facts and Dimensions. It contrasts with ER Modeling in its purpose. The purpose of ER modeling is to store the data in such a way that redundancy is minimized and inserts and updates are quick. Dimensional modeling on the other hand stores the data in such a way that querying or retrieval is fast. When there is...
infiniteandmore.blogspot.com
Information Storage and Retrieval: What is Oracle Wallet
http://infiniteandmore.blogspot.com/2014/02/what-is-oracle-wallet.html
Enter your search terms. Information Storage and Retrieval. Friday, February 7, 2014. What is Oracle Wallet. There are often situations where we have to give database access credentials in a shell script. This can be a security issue as database connection details are explicitly written in these scripts. Oracle provides an option of creating an external password storage mechanism. Posted by Gaurav Kant Goel. Subscribe to: Post Comments (Atom). View my complete profile. Algorithms and Data Structures.
infiniteandmore.blogspot.com
Information Storage and Retrieval: May 2012
http://infiniteandmore.blogspot.com/2012_05_01_archive.html
Enter your search terms. Information Storage and Retrieval. Monday, May 28, 2012. Looping of Workflows in Informatica. Now you have to provide an Informatica solution wherein the the tables in target schema are loaded from corresponding tables in source schema dynamically. i.e there should be only 1 set of mappings for each loading and this set should be called 3 times(since there are 3 source schemas). Everytime the schema name should should dynamically change. Create a control table as follows:. Schema...
infiniteandmore.blogspot.com
Information Storage and Retrieval: November 2013
http://infiniteandmore.blogspot.com/2013_11_01_archive.html
Enter your search terms. Information Storage and Retrieval. Sunday, November 24, 2013. Snowflaking is a form of dimensional modeling in which a dimension is normalized. By moving attributes with low cardinality (few distinct values) into separate dimension tables that relate to the main dimension table by using foreign keys. Snowflakingcan be done in case of:. Sparsely populated attributes, where most dimension member records have a NULL value for the attribute, are moved to a sub-dimension. If your Orac...
infiniteandmore.blogspot.com
Information Storage and Retrieval: September 2011
http://infiniteandmore.blogspot.com/2011_09_01_archive.html
Enter your search terms. Information Storage and Retrieval. Monday, September 19, 2011. Object Oriented Programming: Some Basic Concepts. All computer programs consist of 2 parts: code and data. So, a program can be conceptually organized around its code or around its data. So, there are 2 approaches of writing computer programs: Programs that are written around "what is happening". And programs that are written around "who is being affected". Encapsulation is a mechanism that binds together code and dat...
infiniteandmore.blogspot.com
Information Storage and Retrieval: August 2011
http://infiniteandmore.blogspot.com/2011_08_01_archive.html
Enter your search terms. Information Storage and Retrieval. Thursday, August 4, 2011. To load data in a table efficiently, we can make Indexes as UNUSABLE. However, the TRUNCATE operation should be done before making the indexes unusable. If table is truncated after the indexes are made unusable, then it will have no effect. The TRUNCATE will automatically make the index USABLE. so the correct order to load data will be as follows:. Set the indexes to unusable. Posted by Gaurav Kant Goel. OK, that’...
infiniteandmore.blogspot.com
Information Storage and Retrieval: August 2013
http://infiniteandmore.blogspot.com/2013_08_01_archive.html
Enter your search terms. Information Storage and Retrieval. Tuesday, August 20, 2013. Question: You have 2 tables as follows:. Create table table1(player varchar2(10), ground name varchar2(10), num centuries number);. Create table table2(ground name varchar2(10), country varchar2(10) ;. Write a SQL to list the player names who have made centuries in every country. Select count(distinct country) cnt from table2) g,. And table1.ground name=table2.ground name. Group by player) p. Where g.cnt=p.cnt. Whether ...