from a graph how to select only second record always in scan?

Answer Posted / vipul kumar

Use partition by expression to separate

Is This Answer Correct ?    1 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the steps to create a repository in ab initio?

756


Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?

663


What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?

642


How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC

1487


How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?

725






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

652


What is the difference between a scan component and a rollup component?

618


What are the key elements of a data processing system?

692


What is rollup component?

685


List out the file extensions used in abinitio?

661


Tell us about the architecture of abinitio.

652


Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?

651


What is the architecture of abinitio?

666


What is the function that transfers a string into a decimal?

677


How to move or copy the project parameter or project object to my sandbox?

1820