) 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 output of using partition by Round-Robin after the partiton by key in ab initio?
Difference between informatica vs ab initio?
Pdl with an example?
What is the significance of record required indicator of Join component ?
What is the use of the co> operating system in ab initio?
Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?
What is air-project parameter ?
What is regex (lookup)? When you should use it? How to use in abinitio graph?
. How can you get all the fields form a lookup files ? (Which function)
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.
Can you run air sandbox run using pset ?
What do you mean by the overflow errors?