-
Using Partition components
i having 1000 records in in0 file.
i want first 250 records into out0 file,
next 250 (250 to 500)records into out1 file,
next 250(500 to 750) records into out2 file,
last 250(750 to 1000) records into out3 file using partition components? -
-
-
Graph Performance
I have a master file with user personal details and around 50k users.
Each day a transaction file with about 100million records come in and we need to update transaction file with user details present in master file.
What is a good approach for this? -
-
Unit testing
How do you perform Unit testing?
-
-
Data Modelling
What data modelling do you follow while loading of data to tables? Also the DB you are inserting the data has Star schema or Snow flake schema?
-
-
-
-
-
-
Information required regarding certifications in ETL
Hi All,
I need few suggestion from ETL regarding certification programs.
I have 2.5 years of exp. as Abinitio Developer(ETL). I am on the bench and waiting for a project. Meanwhile I want to gain more knowledge on ETL and I am planning to do certification program. but, I have lot of confusion and doubts regarding the certification programs in ETL area.
Could anyone... -
Doubts on AbInitio
Hi I have a few questions in AbInitio. It would be very useful, if some one answered.
1.How to bring souce files(Flat files) to Unix environment?
2.How to go to GDE from Unix after connected to Unix Host?
3. How to integrate o/p folder / file to target database (SQL Server)?
4.Is staging area required in AbInitio? If yes, when is that?
Please answer these ques. -
-
-
-
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 ?
-
Loading 1 Millon Records
If a graph fails in between loading 1 millon records to a target table what is the alternative solution? I.e Will you run the grarh again? (The record count is very huge)
Abinitio Interview Questions
Ans