TechNData - Tech & Data - The place where the Information Matters

Hadoop is the hot cake in the current IT market, which was currently controlled by Data Warehouse system. Although Hadoop and Big Data concept can be considered as the advanced form of the Data Warehouse, there are various distinctive…
Read More...

Copy(cp) Command Examples: To Copy a file from one directory to another : $cp file.doc new/directory/folder To Make a copy of a file in the current directory as newfile.doc: $cp file.doc newfile.doc To Copy multiple files in a…
Read More...

Some of the major Unix commands used in day to day work: logname ->displays current user name hostname ->displays host name -i to display ip address (io) (/sbin/ifconfig -> to display internet ip address) who…
Read More...

Autosys is one of the most popular job scheduling tools in the software development lifecycle process. It is a task scheduler created using a batch program or UNIX script. To create/run an Autosys job, a user must have either a LINUX or…
Read More...

What is ETL? ETL is a type of data integration that refers to the three steps (extract, transform, load) used to blend data from multiple sources. It's often used to build a data warehouse. During this process, data is taken…
Read More...

Working at the enterprise level company doesn't always mean we should deal with big and sophisticated tools and software. Most of the times the simple and day to day used software used in our non-office time are also useful. In this…
Read More...

Finding the perfect definition of the words you want is always hectic. I have compiled the some of the basic terminologies related to the database based on the reference I got from various tech sites like AboutTech, Raima, eTutorials.org,…
Read More...

Who won't love an SQL query which is finely tuned, well written and which gives higher performance too? I have compiled some of the nice steps we need follow to tune the SQL query and increase the performance of the execution. Use…
Read More...

Slowly Changing Dimensions (SCD) are the dimensions that change slowly over time, rather than changing at a particular interval of the time. In Data Warehouse, there can be the need for keeping track of such changes as historical data. Thus…
Read More...

Microsoft (MS) Outlook is the most common and most popular communication tool used these days. The scope of MS- Outlook ranges from managing the emails to scheduling the meetings, sending the documents, managing the calendar and many more.…
Read More...