) How can you count the total no .of records in the
specified partition in the Multifile?
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 |
What is the role of co-operating system in abinitio?
Mention how can you connect eme to abinitio server?
How do you improve the performance of a graph?
What is the purpose of having stored procedures in a database?
What is use of creating a save files? How to use in abinitio graph?
1 Answers Cognizant, IBM, Intellego, TCL,
Mention some ways for improving performance of a graph?
Explain how abinitio eme is segregated?
What is a deadlock and how it occurs?
Difference between public and private projects and how to make private to public?
What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?
Difference between output_index and output_indexes in reformat
Describe what the SQL Server tempdb and tlog files are used for?