-
Force_error Function
How does force_error function work ? If we set never abort in reformat , will force_error stop the graph or will it continue to process the next set of records ?
-
Data Warehouse as Transaction Database
Can a Data Warehouse also be used for Transaction Database? If Yes Why, If No Why not?
-
Lookup Performance
How does the usage of Dataset improve the performance during lookups?
-
Staging and Operational Data Store
What are Staging and Operational Data Stores and what is their difference? Why does one need staging and why does one need ODS? What will happen if they are not there? Who and how is it decided that a staging or ODS is needed? Which comes first staging or ODS?
-
what is the function of XFR in abinitio
It would be great if one of you can explain me in brief what is the function of xfr (like what does it do ,where is it stored ,how does it affect ) as i am very confused on thisthank you
-
-
Parametrization of MFS
I want to use an Ab Initio parameter to control whether I am in serial or MFS mode. Basically, I will have an $AI_MFS_PARTS variable. If it is set to 1, then we are running serial. If it is set to 4, then we are running 4-way MFS. Will the data need to be located in physically different locations using different control files?
-
Cummulative summary in AB Initio
How can I achieve cummulative sumary in AB Initio other than using SCAN component. Is there any inbuilt function available for that?
-
Output for sort and dedup sort with null key
I have file containing 5 unique rows and I am passing them through SORT component using null key and and passing output of SORT to Dedup sort. What will happen, what will be the output.
-
Join on partitioned flow
If I have 2 files containing field file1(A,B,C) and file2(A,B,D), if we partition both the files on key A using partition by key and pass the output to join component, if the join key is (A,B) will it join or not and WHY?
-
ODS and Staging
What is the difference between ODS and Staging?
-
Abinitio MFS
There is one MF while loading data i deleted one partition in a MF? Can it show error/it will process data?
-
Abinitio Password
In production also do they will give same password which was given in .DBC?
-
Abinitio Display records between 50-75..
In input dataset i am having 100 records. I want records between 50-75 and i don't want to read 5th record? which component i have to use..
-
Changing to MFS
How do change serial file into MFS? Explain
-
Abinitio Air-Project Parameters
What are air-project parameters and air-sandbox? What does it contains?
-
Abinitio Bad-Straight-flow
When did we get error like 'Bad-Straight-flow'?
-
Abinitio Merge Graphs
How do we merge graphs in AbInitio?
-
Abinitio Partitions
What is the difference between partition, re-partition and departition?
-
Abinitio Lookup
Can we process 1 GB data(1 million records) by using Lookup? How
-
Indexes in Abinitio
In Abinitio which type of indexes used?
-
Standard Environment
What is Standarad Environment? What it contains?
-
-
-
-
-
-
What is fan in and fan out in AI ?
whats the difference and explain about usage?
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
What is a Data Warehousing?
Data Warehouse is a repository of integrated information, available for queries and analysis. Data and information are extracted from heterogeneous sources as they are generated....This makes it much easier and more efficient to run queries over data that originally came from different sources. Typical relational databases are designed for on-line transactional processing (OLTP) and do not meet the...