DSXchange

It looks like all you are doing is numbering the rows. You'll have to set the job to execute in single-threaded mode and append @INROWNUM and your separator. Actually I have mentioned one set of records as a sample, data looks like this: Col1 Col2 Col3 abc 123 1 zzz 234 3 abc 123 1 999 895 1 abc 12...

rkashyap, here is data with column header, Col1 Col2 Col3 abc 123 1 abc 123 1 abc 123 2 abc 456 1 abc 456 2 abc 456 3 Output should be into one column: Col_output abc|123|1^1 abc|123|1^2 abc|123|2^3 abc|456|1^4 abc|456|2^5 abc|456|3^6 Requirements: need to find duplicates based on Col1 and give the ...

my data is like this

abc|123|1
abc|123|1
abc|123|2
abc|456|1
abc|456|2
abc|456|3

My output should be:

abc|123|1^1
abc|123|1^2
abc|123|2^3
abc|456|1^4
abc|456|2^5
abc|456|3^6

Thanks

Thank you all.

Thanks for reply, can you explian it more.

anyone has any other methods to achive this?

ratikmishra1 wrote:Join with one input from the file and the other via aggregate stage followed by a filter stage whould work in this case.

I know how to remove duplicates or separate the duplicate rows but My requirement is need process all duplicate rows separately Ex: Input data: 123 AA 124 BB 124 BB 125 CC 126 DD 126 DD 126 DD Out put in two datasets: 1st dataset should only have non duplicate rows: 123 AA 125 CC 2ND dataset should ...

Change Sort stage execution mode to sequential mode and try it. Hello everybody, In my job I am combining 10 files using a funnel. these 10 files are sequential files and 3 fields on these files are common, the first 3 fields. I use a "continuous funnel" and combine them then use a sort st...

Do you think there is any better way to implement the deletes and than the Inserts.Is it safe to use a single job and have 2 links from the transformer 1st link I select the Delete Rows (Write Method) and the 2nd link I insert the rows using the Upsert(Write Method). In the Link ordering first the D...

My insert statement is below in the Oracle Enterprise stage Insert into Table1(col1,col2,col3,col4) values (ORCHESTRATE.col1,ORCHESTRATE.col2,ORCHESTRATE.col3,ORCHESTRATE.col4) I don't see anything wrong with it,as i stated earlier the insert statement works fine if i run just the insert statement w...

Do you think there is any better way to implement the deletes and than the Inserts.Is it safe to use a single job and have 2 links from the transformer 1st link I select the Delete Rows (Write Method) and the 2nd link I insert the rows using the Upsert(Write Method). In the Link ordering first the D...

If I execute just the Insert statement(with out delete and commit) than it works perfectly well.
So the Insert statement is working well .

Thanks

Craig,

when i have placed semi colons I get the below error
oes_Table1: Update prepare failed:
update is: DELETE FROM Table1;
COMMIT;
INSERT INTO Table1
(col1, col2, col3, col4)
VALUES
( :col1, :col2, :col3, :col4);
sqlcode is: -911
esql complaint: ORA-00911: invalid character


Thanks

Hi, I have a job where i read data from a sequential file and load the data into a Oracle table.I have been using Upsert Write Method to get this done(since SQL loader is not configured we are not using the Load Write Method). Now I need to delete the staging table before i insert rows into the stag...

Nope, NLS not installed Without installing NLS is there any way we can handle this situation?

Thanks for reply girija....but it is not related to change capture......I am getting duplicate records on a member from source and I have to populate the dates depend on previous records on that same member.... Use change capture stage and get the new, deleted , changed and copied ( same info) membe...