It can be either (or both).
But usually the latter.

There's so much terminology, it's almost as if it was meant to be confusing !
This is an excellent article for beginners (translated from German, so pardon a few mistakes)

In case of a real time message driven warehouse, the primary challenge arises out of it being "real time" - not because of it being "message driven" (push based)

This is an excellent article - http://dssresources.com/papers/features/langseth/langseth02082004.html

Data cleansing & integrity challenges you'll face, no doubt.
But no more than you would when building a traditional data warehouse.

As reported by user sh_2, the link to Powerpoint presentation file is not working at the moment (the website seems to have run out of bandwidth for the month).

We don't have a shortage of bandwidth, so I'm attaching a copy of the file in this post. (downloaded from Google cache)

edit - Should have mentioned before ... post attachments are visible/available only to registered users.

ProperCase()

Available in Crystal Reports v9 and higher.

Works just fine here.

Result -

What DBMS are you running ?

Welcome to the community, Black-Wolf !

We look forward to sharing data warehousing knowledge and experiences with you.

These haven't been tested, just typed in quickly. Hopefully, they'll still work -

1)
SELECT e.Emp_id, e.Emp_name, e.Mgr_id, m.Emp_name AS Mgr_name
FROM Employee e
LEFT OUTER JOIN Employee m ON e.Mgr_id = m.Emp_id


2)
SELECT e.Emp_id, e.Emp_name, e.Salary
FROM Employee e
INNER JOIN Employee m ON e.Mgr_id = m.Emp_id
WHERE e.Salary > m.Salary

New thread created.

Thanks Allegra !

The earlier logo was just an "open book with a globe" - not the most relevant to Data warehousing.

You mean this "user info" ? Looks pretty much the same even now -

Or did you mean this "user info".

I'm glad you all like it.

Each row of "Master" is compared against the "Detail".
Fewer rows in "Master" means fewer iterations of the transformation.

Also, fewer rows in "Master" means a smaller Data/Index cache.

Reference - http://www.lsp4you.com/seminars/Cache.ppt

You can use the command chmod to change permissions on a file/directory. For example -



If you wish to change the permissions recursively, use "-R" argument with chmod. For example -

The jury is still out on the absolute "best" technology ... but Oracle+Informatica has a bigger market share than MSSQL - that's probably a good indicator.  

A good place to start would be to master the basic concepts of DW. Do that, and it's more than half the job already done.

Personal suggestion - MSSQL BI products come with a very good sample DW implementation called "Adventure Works" - even if you're not focusing on MSSQL, that is a good place to learn the abstract DW basic concepts and their practical implementations.

p.s. - Oracle might have something similar to Adventure Works, but I'm not really an Oracle person.

Hello Thierry !

Welcome to DWforum.net ... hope you have a pleasant knowledge sharing experience here.

Why not do this with a simple query against your source DB, instead of trying to do this in Informatica ?

chgrp is meant for non-privileged users.

Superusers can use chown.

Changes the owner of file1 to user1 and owner group to group1

If you only want to change the group, you can skip the user1, like so -