We have file having country_name customer_name.For exp
London Ram
Bangalore Rohit
London Shyam
Bangalore Abhinav
In output we need 2 files one file for london and second file for Bangalore.How to acheve this?
Answer Posted / keerthika
We can use Partition By expression to partition the data based on the Value in input data
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What are the co> operating system’s assorted library of integrated components?
What are the primary keys and foreign keys?
Pdl with an example?
Can you explain data flow graph with an example?
explain checkin and checkout?
What is abinitio?
State the working process of decimal_strip function?
How can we increase the loading performance of oracle table in AbInitio?
What are the various types of layout supported by abinitio?
What are the benefits of data processing according to you?
How would you find out whether a sql query is using the indices you expect?
What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summarize a group of data record? Then where we will use aggregation?
Why might the optimizer use a table scan when an index is available?
When we should use 'jobid' for commit table (Output table component?? How to use in abinitio graph?
How transaction file different from that of a sort file?