DSXchange

1) Read each row as single char using varchar (Seq file Stage) 2) Use following function to read columns (Transformer stage) Field(Row1,"|", 1) Field(Row1,"|", 2) . . . Field(Row1,"|", 20) You will get expected result .. The above logic will applicable only for fixed co...

Use cast function while reading the oracle decimal values..

For example , Table T1 has column A has decimal datatype (12,3) means

Try to read the above A column value as VARCHAR usinf cast function

Select (cast ( a as Varchar(15)) A
from T1(Table)

This wll help you out ..

Just check with single records alone ... If it suceed ,check with 10 records..
There may be possibility of constraint violation ...

Put a reject file from the DB in datastage and capture ...

Check all the columns thoroughly..

In the Oracle DB target stage,you have to enable output reject records to be true and take a link from that stage and capture it in sequential file..

The design should be
Seq file(source file) ------> Transforer ............> Oracle Table --->Sequential file (Rejected reords )

Open the previous stage and change the preserve partitioning setting to clear..

Open the stage tab in that stage(sort,file,lkup etc).Go to adavnced tab and change the Default(clear) to clear before processing to the next stage(Insert_DMT_TACTICS_FT)....

Each record having length of 1800.. While I am loading into the file ,I need to split these records into three.. Basically I need to insert unix new line after 600 length.. the second and third records 600 column defintion(column length) is different.. How can i load the single record into three row...

I have some doubts on using run time column propagation in Aggregator stage.For example i am reading the data from file and loading into the sequential file through transformer and aggregator stage. If i am using run time column propagation option in other processing stage ,it will work. My curiosit...

the issues are resolved.. first we asked DBA to increase the size of the table.. then we loaded the records into the table.. we created the index on the table.. This took less amount of time (App 2 hours).. Before that we created index on the table and tried inserting the records (290 million) into ...

there is some 290 million records in temp table. There is no primary key and index on this table.Right now i am using this table as look up. I used this table as sparse look-up in ETL job,but the datastage job is still running(More than 15 hours).. One of my friend is telling this is because of the ...

any suggestion??

Please post your comments on this..

I am extracting data from two views based on key column values. The thing is both of the views having more than 100 million records.I am joining the view based on some key columns which is producing some million records. The source is oracle table(40000 records) and i am pulling the records from the...

i was also faced the similar issue.. I didn't noticed the records got rejected while loading into the oracle table due to mismatched datatype between source and target..

1)Put reject file at the oracle stage.
2)Check the datatypes between source and target.

1) Open manager
2) Tools and Run multiple job compile
3) select jobs (like server,parallel,sequencer)
4) manual page selection
5) select whatever the jobs you want to compile

What is your exact requirement?
Do you want extract the records from the table? Give us your business requirement

based on our business requirement we need to process the data like remove duplicates,sort etc.. I am considered the incoming records are not duplicates..