) How can you count the total no .of records in the
specified partition in the Multifile?

Answers were Sorted based on User's Feedback



) How can you count the total no .of records in the specified partition in the Multifile?..

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

) How can you count the total no .of records in the specified partition in the Multifile?..

Answer / shiva

m_wc .dmlfile `partitions multifile`

Is This Answer Correct ?    7 Yes 1 No

) How can you count the total no .of records in the specified partition in the Multifile?..

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

) How can you count the total no .of records in the specified partition in the Multifile?..

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

) How can you count the total no .of records in the specified partition in the Multifile?..

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

Post New Answer

More Ab Initio Interview Questions

Is there any function in ab Initio which act like SCAN component

3 Answers  


I have a DML in my local system the location is E:/u/home/khaleel/dml how to convert this path to $DML?

1 Answers  


what does layout means in terms of Ab Initio?

3 Answers  


what are the steps in actual ab initio graph processing including general,pre and post process settings?

2 Answers  


How will you check the latest versions in EME?

6 Answers  


What is a partition and what are the different types of partition components in abinitio?

0 Answers  


What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?

0 Answers  


Do you think effective communication is necessary for data processing? What is your strength in terms of same?

0 Answers  


In which scenario, .rec files will not get created even if graph fails ? How to use in abinitio graph?

2 Answers   IBM, TCL,


what is macro?At what situation we have to face?

1 Answers  


Define ramp limit in ab initio?

0 Answers  


Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?

0 Answers  


Categories