) How can you count the total no .of records in the
specified partition in the Multifile?
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between check point and phase?
Dear all, Please send me the ab initio pdfs and faqs i need... my mail id is rrajesh.intel@gmail.com
Define ramp limit in ab initio?
What is sort component in abinitio?
What are the components new in 2.14 compared to 1.8 and State the usage of the components?
What do you mean by the term data warehousing?
Tell us about the architecture of abinitio.
What is the difference between partitioning with key / hash and round robin?
What is the purpose of having stored procedures in a database?
Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?
State the working process of decimal_strip function?
Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?
i have a scenario where i need to change the value of a sort order in my sort component whether ascending or descending depend on some input value... e.g if input_val = A then sort order should be ascending else descending I have to use PDL in this... Can you please tell me where do i have to make this change and how ?
What are the operations that support avoiding duplicate record?
How to add default rules in the transformer?