DSXchange

Anu, If you have a copybook,just import it in DS (without the comments) and load it in a CFF stage. The redefine columns will appear like regular ones. You have to pay attention if the redefine is include in a occurs. In that case the redefine column is set to the column of the first occurs. You ca...

balajisr wrote:You can use row splitter to split your 6 concatenated subrecord rows into a 6 seperate rows.

Balaji,

Could you please elaborate a bit more on how to split them into 6 seperate rows...

lovejha2:

I work in that direction and let u update, thanks,

Good morning gurus. In my cobol source file, I have a Sub-Record in Main-Record.Sub-Record contains 5 columns and this Sub-Record occurs for 6 times in Main-Record.I need to load this Sub-Record info into a seperate table. My question is..... How to load these 6 Sub-Records(containing 5 columns each...

Anu Once you made your Job as Muliti Instance job then if you go and open your Sequencer job you will have Invocation Id tab under Job name. This is the place where you need to type in the invocation id for each instance. hope this helps thanks much siva. I got it.... I ran the sample ETLs successf...

Anu Click the Job Properties and inside that tick the Allow Multiple Instance box. It's that easy to make a job multiple instance. While running it you need to give InvocationID which identifies each instance ran for that job. For Custom routine you can start looking at the Routines which comes wit...

Can I have a sequencer above the job which passes 'ABC','XYZ'.....to filename and runs the job 4 ( the no of files I have) times. and loads table. Short answer is 'yes'. How you architect that is another matter. Do you know the four values ahead of time or do they change from run to run? If they ar...

Sure - you can parameterize as much of the filename as you need. Typical parameter usage would be one for the directory the file lives in and another for the actual filename, tacked together in the Filename field of the stage. Something like: #SourceFileDirectory#/#SourceFilename# Or you could para...

Can I use Job Parameter to pass 'ABC'...'XYZ' as i mentioned to 'filename'. so that it will become 'filename_ABC' ....'filename_XYZ'..? I am using SEQ file stage. Sure - you can parameterize as much of the filename as you need. Typical parameter usage would be one for the directory the file lives i...

If the metadata of all the four files is identical and they flow through the same set of transformations and rules. Then yes you can use that one job to process all the four files. Your can make your job multi-instance. Provide the source file names as a job parameter. And run those jobs as seperat...

Welcome aboard. :D Your question suggests some unfamiliarity with job parameters. If you define a job parameter, then you can use a reference to that job parameter (surrounded by "#" characters) in your sequential file stage. However, this would only let you process a single file. To proc...

Hi all: I have 4 files named as below.. filename_ABC.csv filename_DEF.csv filename_MNU.csv filename_XYZ.csv All four files are in same format/structure, but contains different business data. I have an ETL to load "filename_ABC.csv" into Oracle table. My question is...can I use this single ...

Hi Anu If you are using hash file then the column name doesn't really matter. It is just a name you give to read or write. It is same like creating a sequential file and using it in your job. The field order in which you write to a hash file is how you read it back. You can give any name to the fie...

Hashed file navigation is by ordinal number of the field within the record, so that order is vitally important. In a Hashed File stage you have access to the field number in the Columns grid (if completed they are used in preference to the column names); in a UV stage you do not, so must use the ex...

This error indicates that CASE_TYPE is not defined in the metadata (file dictionary) for the UV table (hashed file). Verify either by importing the UV table definition (click on Detail - you don't need to complete the Import process). Beware that column and table names are case sensitive. If it con...

Hashed File stage can only do key-based "=" lookups. If you really do need to lookup against non-key columns in a hashed (not "hash") file, you can use a UV stage. It will be slow unless you index the search columns. Search the forum for more information. Hi Ray, I tried to use ...