- #Informix odbc cast as money serial number
- #Informix odbc cast as money code
- #Informix odbc cast as money windows
limit + (ramp * no_of_records_processed). Graph stops the execution when the number of rejected records exceeds the following formula. The limit and ramp values should pass if enables this option. This is one of the option for reject-threshold properties. Q.What is meant by limit and ramp in Ab-Initio? Which situation it’s using? Answer: The limit and ramp are the variables that are used to set the reject tolerance for a particular graph. Some of the suitable methods are to use a conditional DML or to call the vector functionality while calling the DMLs. Q.What are the most commonly used components in a Ab-Initio graphs? Answer: input file / output file input table / output table lookup / lookup_local reformat gather / concatenate join run sql join with db compression components filter by expression sort (single or multiple keys) rollup partition by expression / partition by key Q.How do we handle if DML changing dynamically? Answer: There are lot many ways to handle the DMLs which changes dynamically with in a single file. Surrogate keys are frequently added to records when populating a data warehouse, to help isolate the records in the warehouse from changes to the natural keys by outside processes.
![informix odbc cast as money informix odbc cast as money](http://3.bp.blogspot.com/-K9hwALEMXuQ/T8t83WhAFYI/AAAAAAAAA0g/2L5gxPcccTc/s960/logo.png)
A surrogate key is a field that is added to a record, either to replace the natural key or in addition to it, and has no business meaning.
#Informix odbc cast as money serial number
For example, a social security number for a person, or a serial number for a piece of equipment, is a natural key. A natural key is a key that is meaningful in some business or real-world sense. A key is a field or set of fields that uniquely identifies a record in a file or table. Q.How to Create Surrogate Key using Ab Initio? Answer. It is useful for record independent parallelism. It is not key based and results in well balanced data especially with blocksize of 1. PARTITION BY ROUND ROBIN: In this, the records are partitioned in sequential way, distributing data evenly in blocksize chunks across the output partition. It is useful for key dependent parallelism. Since it is key based it results in very well balanced data.
#Informix odbc cast as money windows
Available in both Windows NT and UNIX Q.What is the difference between partitioning with key and round robin? Answer: PARTITION BY KEY: In this, we have to specify the key based on which the partition will occur.
![informix odbc cast as money informix odbc cast as money](https://www.synametrics.com/images/odbcMgr.gif)
Data Processing is very fast and efficient when compared to other ETL tools. We can develop applications easily using GDE for Business requirements. Q.What is the difference between rollup and scan? Answer : By using rollup we cant generate cumulative summary records for that we will be using scan Q.Why we go for Ab-Initio? Answer : Ab-Initio designed to support largest and most complex business applications. Informatica has one huge log! Very inefficient when working on a large process, with numerous points of failure. With Ab-Initio you can read data with multiple delimiter in a given record, where as Informatica force you to have all the fields be delimited by one standard delimiter Error Handling - In Ab-Initio you can attach error and reject files to each transformation and capture and analyze the message and data separately. Ab-Initio doesn't need a dedicated administrator, UNIX or NT admin will suffice, where as Informatica need a dedicated administrator. Initial ramp up time with Ab-Initio is quick compare to Informatica, when it comes to standardization and tuning probably both fall into same bucket.
![informix odbc cast as money informix odbc cast as money](http://www.infohazard.org/~jeff/journal/oracle_connect.png)
code, which can be modified to achieve the goals, if any that can not be taken care through the ETL tool itself.
#Informix odbc cast as money code
Ab-Initio is a code based ETL tool, it generates ksh or bat etc. Informatica is an engine based ETL tool, the power this tool is in it's transformation engine and the code that it generates after development cannot be seen or modified. Ab-Initio supports different types of text files means you can read same file with different structures that is not possible in Informatica, and also Ab-Initio is more user friendly than Informatica. We don't have scheduler in Ab-Initio like Informatica, you need to schedule through script or you need to run manually. Component Data Parallelism Pipe Line parallelism. But Informatica supports only one type of parallelism but the Ab-Initio supports three types of parallelisms. Q.Differences Between Ab-Initio and Informatica? Answer: Informatica and Ab-Initio both support parallelism.
![informix odbc cast as money informix odbc cast as money](https://i.stack.imgur.com/G5FER.png)
Q.What is surrogate key? Answer: surrogate key is a system generated sequential number which acts as a primary key.