what is hash file in abinitio? how will it read in
abinitio? in hash file the data files r combine
(file1.dat,file2.dat,file3.dat......etc) how will it divide?
Answers were Sorted based on User's Feedback
Answer / equalizer
There is no comcept of hash file in ab initio.
Couple of scenarios I can think of
1) If the source file is combined data from multiple files
with header-body-trailer for each file. Create record types
and process.
2) If this is a message that contains information of the
data files then use read muliple files component.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / freak.abinitio
Partition by Key uses hash function to distribute output flow
partition according to the key values...
Data may not be distributed across the partition.
hash function: records in file % no.of partitions
| Is This Answer Correct ? | 3 Yes | 3 No |
What do you understand by a cartesian join?
. What is dynamic lookup ?
What are the factors on which storage of data depends?
Difference between private project parameters ,public project parameters and common project parameters?
What is a cursor? Within a cursor, how would you update fields on the row just fetched?
What is meant by Co > Operating system and why it is special for Ab-initio ?
What is local and formal parameter?
Is it possible to create a parameter in the component?
In which scenario, .rec files will not get created even if graph fails ? How to use in abinitio graph?
Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?
When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?
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)?