) How can you count the total no .of records in the
specified partition in the Multifile?
- 5 Answers
- 25120 Views
- I also Faced
- E-Mail Answers
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 |
) How can you count the total no .of records in the specified partition in the Multifile?
Explain what is the architecture of abinitio?
difference betwween check point and phase?
We know rollup component in abinitio is used to summarize group of data record then why do we use aggregation?
How you can test a dbc file ?
What information is provided by .dbc file extension for connecting to the database?
How can I run the 2 gui merge files?
what are the steps in actual ab initio graph processing including general,pre and post process settings?
Difference between public and private projects and how to make private to public?
What does de-partition mean in abinitio?
Can sorting and storing be done through single software or you need different for these approaches?
. How can you get all the fields form a lookup files ? (Which function)
Teradata 
