DSXchange

Thank you both.

When I used the view data feature of datastage I had this : - for integer the values are displayed 1, 2, 3, 4 - for decimal(10, 0) the values where displayed 0000000001., 000000002., 0000000003., 0000000004. I guess it's just a display format and not the internal representation in DataStage. Thank you

chulett wrote:What is your actual Oracle datatype?

It's number(10, 0)

Hi, Memory wise, what gives the best performance, declaring a column int32 or decimal(10,0) ? I'm asking myself this question because I need to load a sql server table into oracle The table consists of columns with the int datatype. In sql server the int datatype is like a number(10) in oracle. In m...

This is not a good news. thanks

Does this mean that when you do a sparse lookup it will always return multiple rows if the lookup condition is met several times ?

thanks

Hi,

I installed the 64 bits version

/opt/IBM/InformationServer/Server/PXEngine/bin/osh: ELF 64-bit LSB executable, x86-64, version 1 (SYSV), dynamically linked (uses shared libs), for GNU/Linux 2.6.4, stripped

thanks

Hi, I have an issue where a sparse lookup is generating multiple rows even if the Multiple rows returned from link property is empty. This is my job design A first oracle connector (primary link) => 3 rows A second oracle connector (reference link) - with the lookup type on sparse => 3 rows The look...

Hi,

I'm running DataStage 8.5 on red hat 6 64bits.

Does the processes of datastage all run as 64 bits process (with more than 2gb of ram) or do some of them run like 32 bits processes.

thanks

Hi,

I wasn't precise enough, I meant when you install it on a 64 bit platform, does it run like a 64 bit process (more than 2gb of ram allocated) or does it run like a 32 bit process (less than 2gb or ram)?

Thanks

Hi,

The title says it all, is datastage a 32 or 64 bit application.

Thanks

kaps wrote:We use separate set of jobs for initial load to handle such requirements. You can just copy the same set of jobs as initial load jobs and just change what you need to change and run only once.

There will be some code duplication, am I right ? or am I missing something.

ray.wurlod wrote:You could always perform an update immediately after the initial load. ...

Hi,

I don't want to update 1 000 000 rows.

Thanks

priyadarshikunal wrote:Intelligent SCD Stage?

Don't remember trying that one, but you may be able to pass that value in parameter? Sorry can't check it at the moment either.

Yes, just like in SAP DataServices where the stage detect if it is the first load then assign a default effective date to the newly generated row.

Hi, In the scd stage is it possible to set the effective date column to a value (during the intial dimension load) and then set it to currentTimeStamp after. The problem that I have now is that it is always set to CurrentTimestamp while for the initial load it should be 1900.01.01. Is there an optio...