DSXchange

Hi ShaneMuir ,

Could you tell me in more detail or If possible can you provide me the unix commands pls.

I need first line and last line for each file.

six extracts are there and in that 4 are like 100000 records.
2 of them are very big like 1300000

Hi, My requirement is: Source: Fixed width file Target:Fixed width file Source file contains header and footer, i need to store that info into a table(staging), and include them while loading into target fixed width file. Could anybody give me an idea how to proceed with this requirement? Thanks in ...

Yes sainath,

I have acheived this by following logic:

If Right(AA,1) = UpCase(Right(AA,1)) then CC else CC /100


Thanks,

Hello All, My input data coming like: AA BB USD 100 USd 101.23 GBP 200 GBp 203.45 Target column is: CC The requirement is, If the last charecter in AA column is lower case(EX: 'd' or 'p') then I need to divide the column(BB) with 100 and load into target column i.e. CC Could you please let me know h...

All, I am using a unique id(for ex: batch_id)as a invocation id for my master sequence. Every time I run the job sequence for multiple times in a day, it is creating the multiple job logs(in status view-DS DIrector) with batch id as invocation id. For ex: My sequence name is 'ABC' and it is checked ...

Resolved - This was due to Duplicate Data which was removed via the Remove Duplicate Stage.

Hi, We have a simple job which reads from a TAB delimited Seq file and applies a couple of simple transformation rules and then writes to an Oracle Table. Strangely when I run this job, it imports 50% of the data from the file and hangs..does nothing..I have to eventually stop the job. The DEV env h...

Hi

We are using DS 7.x
Source/ Target is Oracle
Oracle :- NLS_NCHAR_CHARACTERSET = AL16UTF16
DS:- NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1

If the NLS_NCHAR_CHARACTERSET on oracle is changed to UTF8, what will be the effect on the existing jobs

Appreciate your response

Thanks

Hi,

Source is Oracle and reference stage is oracle, when we perform lookup using transformer, it returns me only the fisrt value(duplicate values) to the output from the reference stage but if we view the data from reference stage , i can see multiple distinct records.

Please adivce.

Hi All, I am getting the issue with FTP stage. My job design is like specified below. Approach 1: FTP Stage------>Sequential File FTP_Enterprise_0: uri : ftp://HOST/PATH/filename.txt is not valid remote file. But i have a file in the above specified remote path. Approach 2: Sequential File------> FT...

Hi,

Iam Getting an issue with complex flat file,
Job is Aborting,because of SIGBUS Error.How to resolve it.


Error:Operator Terminated Abnormally:received signal SIGBUS.

Thanks,
sirisha.

Hi All, I have a scenario to generate the sequence numbers with surrogate key stage for a sequential file. In version 7.5 i am able to generate the incremental sequence numbers. But in 8.0.1 it is not generating the incremental order. My job design is File------>Surrogate Key Stage------>File I have...