Extract block of data and the error reason too. So so urgent
Hi , this is my first enty in our forum.
Problem scenario:
Using informatica tool am loding records from source DB to target DB. While loading some records getting rejected due to some reason. Informatica will capture those rejected records in session log file.now the session log ll be available with rejected records and the reason for the rejection as below ) ...........unwanted details.....again above mentioned things ll come.
between both the required details , some not required data also there.
We can read the reason for the rejection using the value ORA- or the tablename mentioned in the same line.
we can jump to the row value details using the keyword Targ Rowid and from next line we can get the values for each fields and should read the values till the close bracket ")".
I have to loop through the whole session log file to get all the rejected rored with reason. and i want the rejection reason and the values in single row and next record's rejection reason and values in next line ... an so on , in new file.
shell script is preferable. its as ur wish. but give me a sloution
Plz plz help me on this...
Last edited by jim mcnamara; 07-23-2009 at 08:41 AM..
hi all,
very need help urgently :(
i have a problem compare 2 files from solaris, the 2 files its shown below:
data1.log :
6512345678 6512345677 20070131 073824 420
6511111111 6522222222 20070131 103747 87
6522222222 6233333333 ... (2 Replies)
Hi,
I want to extract block of data from flat file.
the data will be like this
start of log
One
two
three
end of log
i want all data between start of log to end of log i.e One
two
three to be copied to another file.
This particular block may appear multiple times in same file. I... (4 Replies)
Hi Friends,
iam running some scripts, which are all off suddenly stopping.
Can any one tell me the reason why it happend.
Is there any reason to stop the scripts.
Thanks
Krishna. (1 Reply)
Hi All,
I have a Flatfile (any delimitation) of millions of lines of data, where in i have to scrubb the data of the line from the position ($1 ) given in input parameter until the length ($2) given in the input parameter. I utilised awk , sed but i am unable to do it.
scrub key - 12345... (7 Replies)
My input:
Data name: ABC001
Data length: 1000
Detail info
Data Direction Start_time End_time Length
1 forward 10 100 90
1 forward 15 200 185
2 reverse 50 500 450
Data name: XFG110
Data length: 100
Detail info
Data Direction Start_time End_time Length
1 forward 50 100 50 ... (11 Replies)
Hi ,
I have a huge file like this
=245 this is testing
=035 abc123
=245 this is testing1
=035 abc124
=245 this is testing2
=035 abc125
=035 abc126
=245 this is testing3
here i have to pull out those lines having two =035 instead of alternative 035 and 245 i.e extract... (18 Replies)
Hi All,
I need ot extrat initial from a file name coming.
For example i have a file TOOL_Test_File1_AK.txt
i need to extract string AK from it that will come prior to .txt
other examples
TOOL_Test_File1_AKA.txt------ output should be AKA
TOOL_Test_File1_KASD.txt------ output KASD... (1 Reply)