DSXchange

Hi All, I have installed datastage 7.5x2 on windows 7 ultimate OS. I have desig ned my first job as below. seqfile ---> filter ---> seqfile when i click 'view data' in sequential file....i am getting the below error message. ---------------------------------------------------------------------------...

I didn't include this property. Thats why we are using "Modify" stage. right?

any more inputs?


my file is as below.


10,aaa,5000
20,,6000
30,ccc,
40,www,

i just saw only empty space. Actualli i gave like handle_null(sal,0). but i didn't see 0. for ename i gave like handle_null(ename,'null'). i didn't see 'null'.

10,aaa,5000
20,null,6000
30,ccc,0
40,www,0

if i give -128 what value will be applied for ename and sal columns. I mean i have declared nullable = no for those two columns. what about 10000000 ? what value will be applied if i use it? i am not getting this. handle_null is equivalent to isnull() function (sqlserver, sybase) ? shall i give hand...

I have designed a simple job as below. Seq File --> Modify --> Seq_File Seq File : eno int not null ename varchar(25) null sal decimal(16,8) null my task is to change these fields from "Null" to "Not Null". So i just used modify stage with specification = handle_null(ename,'') &a...

Hi All, One of my friend tried to install Datastage 7.5 on windows 7 OS. While installing datastage server, he got the below error message. Installation failed.... check uvregen_output.log file. Content of Log file as below: -------------------------------------------------------------- Command = uv...

thanks... any more inputs?

All,

One of my friend got the offer in singapore for $5,500 SGD (per month).

How was the datastage market in singapore?

Is the above amount is upto the market or not?

He has around 6+ years of experience in Datastage.

Dimension table must be loaded first and then the fact table should be loaded.

Ref:

http://www.information-management.com/i ... gination=1

Am I correct?

SURA wrote:So what do you think?

FACT / DIM ?

DS User

Fact table ? I'm sorry..i am unable to fit this concepts in my projects. i have created lot of jobs..though ..i am little bit weak on this topic. I might have implemented this topic in my jobs without knowing them.

Hi Kim,

I wrote a canned solution to audit ETL and it is included with EtlStats.

http://www.duke-consulting.com/DataStage_Tips.htm

can you tell me will it work on 8.1 version too?

All,

Which table data will be loaded first?
how many keys can be created for Fact table?
how many keys can be created for Dimension table?

Yes...This is the interview questions...one of my friend recently faced the above questions.

The interesting part which i noticed was... i can see three symbols -> means sequential to sequential => <No idea> <> means sequential to parallel (Note, I gathered the meaning for the two symbols from my previous post) is the above meanings are correct? is there any other symbol used in SCORE? wher...

RowGen = Hash Partitioner (sequential Row_Generator_0) eOther(APT_HashPartitioner { key={ value=KEY_1, subArgs={ asc } }, key={ value=KEY_2, subArgs={ asc } It uses 2 keys. Sort = Unable to find })<>eCollectAny op1[2p] (parallel Sort_2)} ds1: {op1[2p] (parallel Sort_2) Don't see any word before <>eC...

All, I have two set of SCORE for a given job. Seq File --> Filter --> Dataset #1: For SeqFile --> Keep File partition = True For Dataset : --> Partition = Auto main_program: This step has 3 datasets: ds0: {op0[1p] (sequential Sequential_File_0) [pp] eSame->eCollectAny op1[1p] (parallel Filter_26)} d...