DSXchange

My extract file is the variable length file with two different cobol layouts. I have to choose the layout depends on the REC_TYPE column. File is in the binary format.

I have no idea how I could achieve this in the Data stage.

Any help is greatly appreciated.

check for the uvodbc.config file in your project folder. Syntax to add DSN is there in the file.

-Sandeep

Thanks Ray Wurlod .It will help us
Thanks

Hi All,

I used following function to remove Leading and Trailing spaces.

Empname= string_trim[" "](Empname)


I think this is what you are trying to know.

Thanks,
rgandra

It should be parllel

Hi Everybody, Please help out with the following scenario. I have a target fact table which contains about 30 millions of data which contains two main column tgt_month,Count. Source file has the src_load_month and src_eff_month. If the src_load_month > src_eff_month from the source file then 1)get t...

You can use DSAttachJob,DSGetLinkInfo job control routines. you will find their description in the server job documentation.

-Sandeep

Probably your passing nulls or empty strings to the key colums in the hash file.

If this don't help give me more description about the job design.

-Sandeep

target File Constraint: DSLink.NOTFOUND
reject file constraint: DSLink.NOTFOUND=@FALSE

Assuming DSLink is your HASH LINK name.

-Sandeep

Use commas.

If you know the format of the header and trailer record, you cna filter those records by adding contraint in the Transformer stage.

My tables are in different data base so i can not write the following delete statement And there are no partitions on that [quote="kcbland"]If I was to experiment, I would create a table that matches your dataset and run that dataset into the table. Enable parallel on that work table, alte...

[quote="kcbland"]Sure. 1. Look at the load on the server/nodes. Do you have full resources? 2. Look at the queries running against the table. Anybody doing stuff? 3. Look at the indexes. Are there a lot? 4. Look at the indexes. Are they partitioned and are they global or local? 5. Look at ...

Hi, I am using delete statement in oracle enterprise stage and write method is "delete" but the performance is very low i.e 50 rows per second. my scenario is dataset--->oracle enterprise stage my delete statement is delete from table where col1=ORCHESTRATE.col1 Can anybody help me. Thanks...

HI kDuke,
Thanks for the reply.Now it is working fine.I forget to check the multiple Instances.
Thanks