) How can you count the total no .of records in the
specified partition in the Multifile?
- 5 Answers
- 24380 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 |
What is standard environment ?
What exactly do you know about the typical data analysis?
Mention how can you connect eme to abinitio server?
Hi friends if u don't mind i want one question What abt READ MULTIFILE COMPONENT? PLZ GIVE BRIEFLY?
What are the various types of layout supported by abinitio?
What are the differences between different versions of co-op?
What is the significance of record required indicator of Join component ? How to use in abinitio graph?
If m loading a file of 1 million records.and the graph fails after loading 10,000 records. In this case if we use rollback command then what will happen?
What is the function that transfers a string into a decimal?
What is Is_defined(), Is_null(), Is_Blank()?
What are the steps to create a repository in ab initio?
11. What is the use of allocate()?
Teradata 
