) How can you count the total no .of records in the
specified partition in the Multifile?
Answers were Sorted based on User's Feedback
Answer / puneet
m_cat <mfs file name> | wc -l
gives the record count in mfs file provided every record are present in new line..
Is This Answer Correct ? | 10 Yes | 3 No |
Answer / prakashbalakrishnan
In Multi Files, data's are stored in individual partitions.
i.e. for 3 way partition, it will stored as
/wload/xxx/xxx/1way/../test.dat,
/wload/xxx/xxx/2way/../test.dat,/wload/xxx/xxx/3way/../test.dat
SO in unix u can easily the find the different partitions
and for the corresponding partition u can get toal no. of
records by using wc command.
Is This Answer Correct ? | 7 Yes | 2 No |
Answer / learner
use m_expand command, it will give list of partitioned file, than wc -l on specified file name give number of records
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / pramod k m
First do
cat <mfs filename>
Then
cat <complete path of the data partition> | wc -l
Is This Answer Correct ? | 1 Yes | 1 No |
Is there any function in ab Initio which act like SCAN component
I have a DML in my local system the location is E:/u/home/khaleel/dml how to convert this path to $DML?
what does layout means in terms of Ab Initio?
what are the steps in actual ab initio graph processing including general,pre and post process settings?
How will you check the latest versions in EME?
What is a partition and what are the different types of partition components in abinitio?
What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?
Do you think effective communication is necessary for data processing? What is your strength in terms of same?
In which scenario, .rec files will not get created even if graph fails ? How to use in abinitio graph?
what is macro?At what situation we have to face?
Define ramp limit in ab initio?
Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?