If data is still loading into table what mode will you use to see the data?

notjustaprettygirl

• Jul 24th, 2017

API mode. The main difference between the two modes - API and utility is that API commits after predetermined number of transactions where as utility commits only after all transactions have been processed. Hence API is slower but recovery is faster and utility is faster but recovery is slow.

Answer Question  Select Best Answer

How to delete a record from a multifile?

Sandeep

• Sep 10th, 2017

Linux command:
vi `m_expand -native file_name`
it will expand the control file and allow us to edit in all partition.

SP

• Jun 5th, 2017

a. Build a duplicate graph with the same logic that processes the file b. Select Never Abort for that component where a failure may occur. c. Arrange Reject port for that component and run the grap...

Answer Question  Select Best Answer

If a DML is changed, how to find out the impacted objects using a command?

sandeep

• Sep 11th, 2017

"air object uses" has been replaced by "air object referencing-files"

Jagnyadatta Sena

• Jul 26th, 2017

We can use all below:
air uses
air object uses .

Note: If dependency analysis is not there for the checked-in object, these commands will not show any output

Answer Question  Select Best Answer

How to modify record in multifile if data is ASCCI and if data is Obserddata?

Mahesh

• May 26th, 2021

To check malformed records you can use m_dump -partial option.This option shows any incomplete records.Else run the graph and attach a reject and error port to see

SP

• Dec 11th, 2017

1. View data and get the malformed record using m_dump. Note down that record number(s). 2. Using Filter by Expression, deselect only that/those record(s). 3. Using Reformat, specify values manually...

Answer Question  Select Best Answer

How to find corrupted record in multifile?

Monika Rani

• Aug 25th, 2017

M_dump dml file -show-partial -partition n

by giving value of n, check for each partition

Preetilagna Dash

• Aug 22nd, 2017

M_dump dml fileurl -show-partial

Answer Question  Select Best Answer