Interested to Buy Any Domain ? << Click Here >> for more details...
) How can you count the total no .of records in the
specified partition in the Multifile?
- 5 Answers
- 27251 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 we can remove temp files of a failed job if .rec is not available
what is the difference between ab_work_dir and .work
If you check in one file twice in EME, one with a tag and second without a tag - Will the version number change ? How to use in abinitio graph?
Mention what is abinitio?
Why creation of temporary files depends on the value of MAX CORE ? How to use in abinitio graph? 10. What is the diff between abinitiorc and .abinitiorc files ? How to use in abinitio graph? 11. What is the use of allocate()? How to use in abinitio graph? 12. What is use of branch in EME ? 13. How you can break a lock in EME ? How can you lock a file so that only no one other than EME admin can break it ? How to use in abinitio graph? 14. When you should be using ablocal() ? How you can use ablocal_expr? How to use in abinitio graph? 15. Why you should not keep the layout as 'default' for input table component ? How to use in abinitio graph? 16. What is dynamic lookup ? How to use in abinitio graph? 17. What is dependent parameter ? How to use in abinitio graph? 18. What is BRE ? (Business Rule Environment - This is a recent addition in abinitio package) How to use in abinitio graph? 19.What is output index ? How to use in abinitio graph? 20. How you can track the records those are not getting selected from ‘select’ in reformat component ? How to use in abinitio graph? 21. Can we have more than one launcher process for a particular graph ? How about agent ? How to use in abinitio graph? 22. There are lot of new fuctions added in 2.15 , you can ask about them ? How to use in abinitio graph? 23. How can you run multiple instances of a graph in parallel? How to use
How to migrate the code FROM development to QA and QA to production?
What is a rollup component?
What are the different types of parallelism in ab initio?
Explain how you can run a graph infinitely in ab initio?
We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?
When we should use 'jobid' for commit table (Output table component?? How to use in abinitio graph?
what is the difference between i)public ii)private iii)common and client projects?
Teradata 
