DSXchange

I am merging two dataset to one

I find the error as follows,

<_PEEK_IDENT_> Input dataset does not have field: "sstatus".


Any idea about this....

For this situation,
Read the file as fixed lengh field and then try to solve the delimiter issue in transformation

Hope it works!

You can use the Aggregator Stage with first column as key and get the sum of the second column

We tried the pivot stage ,but it gives only null output...

Do we have to enable any other property in pivot?

Thanks

Hi all,
I have a input file like this,

Col1,Col2
a,5%
a,6%
a,7%
a,8%


I need the output as
a,5%,6%,7%,8%

Any ideas to solve this issue??

Thanks in advance,

How much command line UNIX experience do you have? You need to navigate to the 'Project' directory in question and do an 'ls -ld' on RT_SCTEMP there: cd $DSHOME/../Projects/<YourProjectName> ls -ld RT_SCTEMP That should work unless your projects are in a non-standard location, in which case you'll ...

I tried to view the dataset through Data Set management ,but it throws the following error

Error writing to RT_SCTEMP/RunParallel_9876.573486.sh

Do i have to get any privilages for this ?

I developed a new job with the same work flow and Query(Changed).
Now it work fine..

I could not get where is the actuall problem in the Copied Job,??

Any way the Problem is solved !

The Changes doesnot make any difference in the Query.....
I even tried the same query to run the new JOB, but still the error exists!!!

Any ideas??

More Information:
Oracle Enterprice Stage --> Dataset Stage

I just copied an excisting job and made some changes in it..
The Original Job is running fine!!

Hi, Did you rebuild the stages or simply added the schema prefix to the existing table name? If you didn't rebuild the stage try it and see if the error persists. IHTH, Hi, I am in the similar situation and tried the above solutions, but still i am getting the error ORACLE_STAGING: GenericQuery:esq...

You can find the Online Document Package with your DS..Or search in your favourite search engine ,,you can find it...

Please search for the topic before posting it,

Click this post for more reference!!

viewtopic.php?t=102753&highlight=remove ... characters

Search for it before posting,
Hope this will help you,

viewtopic.php?t=121898&highlight=SIGSEGV

Hope this work,
Aggregate by the key with the Count option and then filter it using the count value which is greater than 1