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?
- 2 Answers
- 14220 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What do you understand by overflow errors?
How data is processed and what are the fundamentals of this approach?
Mention what dedup-component and replicate component does?
How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on
Code check-in and check-out commands in AbInitio
What are the different types of parallelism in ab initio?
What is publickey and private key?what is the use of this two keys?
Describe what the SQL Server tempdb and tlog files are used for?
What are the features of ab initio?
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
How can you SORT an already partitioned (round-robin) data ? How to use in abinitio graph? 3. How internally partition by key decides which key to send in which partition ? How to use in abinitio graph? 4. What is PDL ? Give him a shell type parameter and ask him to convert it to PDL. How to use in abinitio graph? 5. As shell type parameters are not supported by EME, then how you can use shell type parameter (If you don't want to use PDL) without hampering lineage diagram ? How to use in abinitio graph? 6.How you can generate dml from a COBOL copy book ? How to use in abinitio graph? 7. How you can convert from ebcdic to packed decimal ? How to use in abinitio graph?
What are the various types of layout supported by abinitio?
Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?
When using multiple dml statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?
How to add default rules in the transformer?
