DSXchange

correct if im wrong !
raj wants how to load data which comming from seq file to oracle database .

seqfile------->transformer------>Oracle .

its a char(10)

example :-

col1:char(10):"sam"
in unix o/p is seen like

col1<value>
sam

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 ?

hi !

can aggregator will be used for sorting !
we have 2 options in aggregator
1. ignore
2. ascending
3. desending
what does it mean ?

covert system date and date into into icnov and then minus ..
after that divided 365..
i think this will help u!

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 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...

I dnt want any data while reading the table from DB3 Table.

example :-
tabel <emp >
dob name
05/05/2005 simi
06/06/2002 rimi

while reading source i dnt wnt this data.

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...

Hi !
my source system is DB2 i have to truncate the records from source while reading source ..

how it can be done

its not working ! i had tried ..

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 .