Answer Posted / guest
3 data,component and pipeline
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What information is provided by .dbc file extension for connecting to the database?
What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.
What are the differences between informatica and abinitio?
Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?
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?
What is conduct>it?
How co>operating system integrates with legacy codes?
What is the difference between partitioning with key / hash and round robin?
What are the Types of parallelism in detail?
Explain what is the architecture of abinitio?
What do you mean by the overflow errors?
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)?
How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on
What a local lookup is?
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?
