How will u remove header record? How will u remove tailer
record?
Answer Posted / dhirendra
There can be many ways to remove header & trailer record
depending on the data you are receiving. If you have a
particular signature for header & Trailer record you can
use Filter by Expression or Partition By Expression
Component to remove the header & Trailer record. If you
don't have signature for your header & Trailer record then
you have to use reformat component to select only the data
record.
Is This Answer Correct ? | 14 Yes | 4 No |
Post New Answer View All Answers
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 ?
How would you find out whether a sql query is using the indices you expect?
Have you used the rollup component? Describe how?
Explain the ab initio etl tool in high level?
Input - Name|city |startyear Rahul |Mumbai|2010 Rahul|kolkata|2014 Rahul|Delhi|2018 Output should be- Name|city |startyear|endyear Rahul |Mumbai|2010|2014 Rahul|kolkata|2014|2018 Rahul|Delhi|2018|9999
What is the function you would use to transfer a string into a decimal?
What is sandbox?
What are the key elements of a data processing system?
Explain the methods to improve performance of a graph?
How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?
How many components in your most complicated graph?
What are the facts that can compromise data integrity?
State the relation between EME, GDE and Co-operating system?
What information is provided by .dbc file extension for connecting to the database?
What is the difference between look-up file and look-up, with a relevant example?