LOAD DATA LOCAL INFILE will read a file that is on the machine where you are
running the mysql client. For eg., your Laptop.The file willbe sent
over the network to the MySQL server host.

LOAD DATA INFILE will read a file that is already present on the machine running the
mysql server.

ODS or Operational Data Store is the central repository where-in the Transactional Data from multiple Systems in the Organization is loaded into.The relevant data from ODS is brought over to the Staging Area and then Loaded into the DataWarehouse.

DataMarts holds related data and can be equated as a break up of the information held in the Datawarehouse.

Depending on whether Top-Down or Botton-up approach is being followed DataMarts are built from DataWarehouse or Vice-versa

Data warehouses are not necessarily no-volatile and undergo changes.The point to be stressed upon is that they are not as volatile as real-time Data Stores or OLTPs which can undergo changes frequently

Nothing to Beat CA ERwin® Data Modeler  when it comes to Data Modelling 

Using Analyis Studio u can:

-Find and focus on items that are important to your business
-Explain trends and anomalier
-Compare data,such as details to summaries,or actual results to budgeted results
-Assess performance by focussing on the best or worst results
-Establish a relative importance using calculations such as growth or rank

Moderated

Adding on to Sipras comment.Its better to brush up your DW understanding and then take up Cognos in particular.

Ab initio is not as widely used as Informatica.Which i believe is maily due to the lack of proper marketing and its lack of user friendliness.

Otherwise Ab Initio is very capable of handling huge amounts of data.And is probably the best ETL tool for enormous data currently in market.Not sure on how it will pitch against Netezaa though.

Moderated.

Where is a filter executed at row level

Having by is a filter that is executed over aggregated data.

It is

Describe table <Table Name>

Checkout for Whoever's reply more details -

Moderator - No Spamming

As pointed out the request seems to illegal in nature.

But you can very well download the developer edition of Information 8.1 at

I think you can get it from below source -

Pass your comments and thoughts on the pros and cons of Informatica well pitched against SSIS(MS-BI)

Dimensional Modelling is restructuring your relational or hierarchial DB structure to the Dimensional Structure which consists of generally a SnowFlake or Star schema with data seperated into Facts and Dimensions.

I thinks informatica website is the best place to check for tutorials.There are some good blogs out there which offer tutorials and mappings too.

Congrats on your choice of tool.Informatica is indded the champion among ETLs