) 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 will be the skew for, input file->partition by key-> partition by round robin->output file
the inputs are 10,20,30,40,50 but the output was comes 0 records,the graph was failed what is bad situation?
Why might you create a stored procedure with the with recompile option?
Do we really work with ACTUALDATA in development phase.
How will you check the latest versions in EME?
How abinitio eme is segregated?
What is a data processing cycle and what is its significance?
what does layout means in terms of Ab Initio?
How to move data from developement to testing and testing to production?
1 Answers BitWise, CTS, Satyam, Wipro,
Mention what is a partition and what are the different types of partition components in abinitio?
Hi friends, what are the new features in abinito3.0?
wt is meant by repartioning in howmany ways it can be done.