Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by etistudent
-
NULL key in fact table or NULL row in dimension??
Hi! Let's say we have two dimensions: customer and vendor, and one fact table with columns: customer_id, vendor_id and value. In one row in fact table we can have reference to customer dim or vendor dim (never to both of them). Is it better to put in customer and vendor dim row with NULLs in...- etistudent
- Thread
- Replies: 1
- Forum: Data Warehousing/Big Data
-
Connection to MySQL server on remote machine via ODBC
Still I don't know what the problem solution is but , when I have installed and started to use iODBC manager instead of unixODBC everything works fine!!- etistudent
- Post #3
- Forum: Data Management Tools general discussion
-
How connect to MySQL server via ODBC adn Datastage under Linux?
Can you tell me what I must install and what I must configure and how to connect to MySQL server on remote machine using DataStage 7.5 under Linux RedHat?? Rgds Luk- etistudent
- Thread
- Replies: 1
- Forum: Data Management Tools general discussion
-
Connection to MySQL server on remote machine via ODBC
Hi! I'm trying to get table definition and data from MySQL server on remote machine. I'm using DataStage 7.5 on Linux, unixODBC drivers and myODBC drivers. Connection to localhost works OK! Connection to remote MySQL is OK, but when I want to import MetaData I have an error: Error calling...- etistudent
- Thread
- Replies: 2
- Forum: Data Management Tools general discussion
