what is the difference between the .dbc and .cfg extensions
and give any clear information ?
Answers were Sorted based on User's Feedback
Answer / raj shekar nagula
A .dbc file has the information required for Ab Initio to
connect to the database to extract or load tables or views.
While .CFG file is the table configuration file created by
db_config while using components like Load DB Table.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / sohan
.dbc is for Database Connection.
.Cfg is for Remote Connection.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / suresh
we can use a single .dbc file across project level, do not mention any hod coded values in the file.
coming to each module in a project user need to provide the details in configuration file
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / equalizer
There is no difference , ab initio now uses the term ".dbc"
file to store the database configuration info. earlier it
was called ".cfg"
| Is This Answer Correct ? | 2 Yes | 4 No |
How you can generate surrogate key? How to use in abinitio graph?
2 Answers IBM, TCL, Torry Harris,
the inputs are 10,20,30,40,50 but the output was comes 0 records,the graph was failed what is bad situation?
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?
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)?
Layout - L1*, L1 - What is the difference ? How to use in abinitio graph?
What is the difference between reformat and redefine format?
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 is broadcasting and replicate?
What exactly do you know about the typical data analysis?
How do you add default rules in the transformer?
Explain batch processing in ab initio?
How to get DML using Utilities in UNIX?