) How can you count the total no .of records in the
specified partition in the Multifile?
- 5 Answers
- 24362 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 data mapping and data modelling?
Mention what is rollup component?
What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?
How can you increase the number of ports of your output flow? What is the limit? Can i have 20 out ports?
Have you worked with packages?
i need help from u. i want to learn abinitio. please provide pdfs or material or books.
What are the prioritized Rules in as Transform function
can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................
When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?
Can you explain the co>operating system’s processing model?
What will be the skew for, input file->partition by key-> partition by round robin->output file
How can you find the 2nd Highest salary in a file department wise in abinitio?
Teradata 
