) How can you count the total no .of records in the
specified partition in the Multifile?
- 5 Answers
- 24282 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 / 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 |
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 ? | 0 Yes | 0 No |
hi, am put into Ab initio now. I need some material for to learn it!! i have to give a test also.. can anyone help me provide material please....
Difference between private project parameters ,public project parameters and common project parameters?
What is the default layout of a component ? Is it mandatory to set the layout of a component ?
Which component breaks the pipe line parallelism in graph?
How does PBK and Sort component and Join(in memory sort) work?I mean in the join component i have used In Memory Sort,so how will it work in terms of performence as compared with PBKand Sort Component?
how many types of project we can create in Abinitio? I mean public,private.......etc?
What is the difference between check point and phase?
what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?
What is the difference between Generate Records Component and Create Data Component?
What are the reasons for which business can trust the approach of data processing?
I have $AI-SERIAL/DML------> (SERIAL FILE LOCATION) AND $BDS-SERIAL/DML---------->(what is the location what is mean)?
Can you explain the co>operating system’s processing model?
Teradata 
