DSXchange

Thanks for your inputs. So, that implies that for a logical dimension CUST_DIM, I will be using two physical tables created in target having same structures but different data loaded based on different frequencies from the set of source tables. Do we do it this way, or can we avoid this by having SC...

Hi Kumar Thanks for your inputs. I wanted to know, if frequency also is considered while modeling a Conformed dimension. If that is true, than this dimension should not be conformed. You mentioned that ou prefer second approach. In the second approach, could you brief me about how and where are you ...

Wanted to add that, these dimensions are type 1 and not type 2.

Can anyone give their thoughts on this.

Hi Gurus I am having a scenario in which two fact tables are sharing two set of conformed dimensions. One is considered a daily fact, while the other a monthly. Can this be possible, if the dimensions are conformed. Correct me if I am wrong. Shouldnt the conformed dimensions be at the same granulari...

I am trying to test this using some samle load. I am using an ODBC stage to pull out 100000 records from a table. I am then populating these records to a Sequential file. In the next job I am using this sequential file as source to populate a dataset. This job hardly takes any time. While, when I us...

Connecting to the Remote oracle server wont be a overhead. If I use a flat file, it wont require connection the way Oracle server would need.

In our case we have Oracle installed on different server. Still, will it be better to use Oracle in place of flat file.

Hi

We have a requirement in which our source system type is being finalized.
Is it better to use flat file as source and retrieve data from there or from oracle directly.

Oracle is on a remote server.

Which one to go for and why

Thanks

Hi Kris

Did you or any one ever used Oracle enterprise stage to connect to oracle, when DS is on different server and Oracle is on different server.

If yes, can you tell what all is needed for configurations.

Thanks

Hi ds

this post says it can

http://dsxchange.com/viewtopic.php?t=10 ... 12f0ec46b9

thanks

Hi I have to configure Oracle enterprise stage to get it working. I have my Datastage installed on Server 1 while Oracle is on Server 2. Could you provide me the steps to configure this. Just adding the Oracle_home, path and Lib details will be enough or do i need to install something else also. Tha...

I don't understand why one would even consider using ODBC. No matter where your Database is(same box or remote), communication between DataStage and Database using Native Plug-ins is far better than ODBC. (Period!). Kris, I have been using Oracle EE stage for all my past projects, but here the clie...

Thanks for the reply. Could you please let me know In case Oracle is on the same server as DS, then Oracle Enterprise is better than ODBC. Can you explain me how and in what sense. Will it be better in case of performance w.r.t Select or for all DMLs. In case Oracle in not on the same server then, w...

Hi Gurus I am wondering if, I should use ODBC stage or the Oracle Enterprise stage for db connection. ODBC is generic stage, while Oracle EE is a native stage having native drivers which may give an edge for performance. But is this the only difference or, do we have additional features which are no...

There a a lot of Unique features available for each stage.

for example,in sort if you say allow duplicates=false then the first rows is retained.On remove duplicates you get an option which one to choose..

Edi