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
- 26986 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 |
Do you think effective communication is necessary for data processing? What is your strength in terms of same?
What is the Reformat Layout?(i/p ->Reformat->o/p)
Pdl with an example?
What will be the skew for, input file->partition by key-> partition by round robin->output file
What exactly do you know about the typical data analysis?
What is standard environment ? How to use in abinitio graph?
what is difference between chk point n phase.Say im loading a file (containig 1 lakh records) and my graph fails after loading 50,000th record.What is the advantage of using check point in this case. Will i be able to start from 51000th record.
Within a cursor, how would you update fields on the row just fetched?
State the relation between EME, GDE and Co-operating system?
We know rollup component in abinitio is used to summarize group of data record then why do we use aggregation?
How to Create Surrogate Key using Ab Initio?
How you can test a dbc file ?
Teradata 
