DB2\UDB Enterprise Stage doubt
Posted: Tue Jan 16, 2007 7:09 am
Hi, I'm trying to use the DB2\UDB Enterprise Stage but I'm having some doubts:
Scenario:
- My DB2 is 8.1 ESE with the DPF(database partitioning feature) must be installed.
- The target table isn't partitioning.
- The database DB2 is 64 bits.
- The datastage server and database server are differents machine.
- I want to use the "Write Method=Load"
Questions:
1 - I already know that datastage work 32bits, then do I need to install a 32bits client or a 64bits client to connect to the database?
2 - "Write Mode=Replace" x "Write Mode=Truncate" what's the real difference? I understood that when I use "Replace" the process drop and recreate the table and when I use "Truncate", well that's is the point. The truncate from Oracle clear and insert the table without drop and recreate it but "Write Mode=Truncate" well I realy didn't understand it.
3 - In the Target yet: I need to put the table target, but I saw at the stuff that I have to indicate the table partition that will be loaded, how to indicate the partition if the table isn't partitioned?
4 - Let's assume that "owner=dw" and "table name = ft_churn" then I'm putting "Table=dw.ft_churn" where I need to put the partition?
Sorry by so many questions but I'm new in "DB2\UDB Enterprise Stage"
Regards,
Fernando
Scenario:
- My DB2 is 8.1 ESE with the DPF(database partitioning feature) must be installed.
- The target table isn't partitioning.
- The database DB2 is 64 bits.
- The datastage server and database server are differents machine.
- I want to use the "Write Method=Load"
Questions:
1 - I already know that datastage work 32bits, then do I need to install a 32bits client or a 64bits client to connect to the database?
2 - "Write Mode=Replace" x "Write Mode=Truncate" what's the real difference? I understood that when I use "Replace" the process drop and recreate the table and when I use "Truncate", well that's is the point. The truncate from Oracle clear and insert the table without drop and recreate it but "Write Mode=Truncate" well I realy didn't understand it.
![Embarassed :oops:](./images/smilies/icon_redface.gif)
3 - In the Target yet: I need to put the table target, but I saw at the stuff that I have to indicate the table partition that will be loaded, how to indicate the partition if the table isn't partitioned?
4 - Let's assume that "owner=dw" and "table name = ft_churn" then I'm putting "Table=dw.ft_churn" where I need to put the partition?
Sorry by so many questions but I'm new in "DB2\UDB Enterprise Stage"
![Crying or Very sad :cry:](./images/smilies/icon_cry.gif)
Regards,
Fernando