correct if im wrong !
raj wants how to load data which comming from seq file to oracle database .
seqfile------->transformer------>Oracle .
Search found 12 matches
- Mon Jan 30, 2006 3:26 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Joining A sequential file and Database table
- Replies: 11
- Views: 3913
- Tue Jan 24, 2006 5:31 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: how to print in next line
- Replies: 8
- Views: 3754
its char(10)
its a char(10)
example :-
col1:char(10):"sam"
in unix o/p is seen like
col1<value>
sam
example :-
col1:char(10):"sam"
in unix o/p is seen like
col1<value>
sam
- Tue Jan 24, 2006 4:57 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: o/p is seq file how get data into in newline
- Replies: 4
- Views: 2197
o/p is seq file how get data into in newline
hi all,
o/p
"hellohow are u " : parameter
this parameter need to be print in next line
like
hello how are
parameter
how to achive this ?
o/p
"hellohow are u " : parameter
this parameter need to be print in next line
like
hello how are
parameter
how to achive this ?
- Thu Jan 19, 2006 7:34 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: can aggrigator will be used for sorting !
- Replies: 1
- Views: 1346
can aggrigator will be used for sorting !
hi !
can aggregator will be used for sorting !
we have 2 options in aggregator
1. ignore
2. ascending
3. desending
what does it mean ?
can aggregator will be used for sorting !
we have 2 options in aggregator
1. ignore
2. ascending
3. desending
what does it mean ?
- Wed Jan 18, 2006 2:58 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Calculating age using date
- Replies: 9
- Views: 26259
Re: Calculating age using date
covert system date and date into into icnov and then minus ..
after that divided 365..
i think this will help u!
after that divided 365..
i think this will help u!
- Fri Dec 30, 2005 6:52 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Regarding NULL
- Replies: 4
- Views: 2280
Regarding NULL
Hi frnds !
i want to know wethere !
1) Trim(input," ","B") gives the result empty i.e "",
whether this "" equals to @Null..
so if it is Same can we specify Trim(input," ","B") = @Null
so, ""=@null specify yes or no
i want to know wethere !
1) Trim(input," ","B") gives the result empty i.e "",
whether this "" equals to @Null..
so if it is Same can we specify Trim(input," ","B") = @Null
so, ""=@null specify yes or no
- Mon Dec 19, 2005 8:10 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: how to create shared container for oracle
- Replies: 2
- Views: 1671
Re: how to create shared container for oracle
I got ..........i was bit confused but atlast i did it thnks all Hi all, my source is oracle ! i want to create shared conatiner for orcale .. i have done shared conatiner for flat files . but im getting confused creating shared container for oracle stage example :- select salray,basesalary from emp...
- Mon Dec 19, 2005 7:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: i wnt to truncate the data while reading the from source
- Replies: 3
- Views: 2178
- Mon Dec 19, 2005 6:30 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: how to create shared container for oracle
- Replies: 2
- Views: 1671
how to create shared container for oracle
Hi all, my source is oracle ! i want to create shared conatiner for orcale .. i have done shared conatiner for flat files . but im getting confused creating shared container for oracle stage example :- select salray,basesalary from emp where dept = 10 and age = 30. here i have 3 columns in oracle st...
- Mon Dec 19, 2005 4:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: i wnt to truncate the data while reading the from source
- Replies: 3
- Views: 2178
i wnt to truncate the data while reading the from source
Hi !
my source system is DB2 i have to truncate the records from source while reading source ..
how it can be done
my source system is DB2 i have to truncate the records from source while reading source ..
how it can be done
- Thu Dec 15, 2005 3:50 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: problem reading data from oracle through sql builder
- Replies: 5
- Views: 2166
- Thu Dec 15, 2005 3:16 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: problem reading data from oracle through sql builder
- Replies: 5
- Views: 2166
problem reading data from oracle through sql builder
problem in read data from orcale stage !
exp:- after selecting tabel from sql builder .. view data is not showing any data (all connections are prefect).
when i try with customized sql statment i can able to read the data from oracle .
exp:- after selecting tabel from sql builder .. view data is not showing any data (all connections are prefect).
when i try with customized sql statment i can able to read the data from oracle .