...

+91 78994 89468 | 78994 89384

Ab Initio Training in BTM, Marathahalli, Bangalore & Best Ab Initio Training Institutes in Bangalore

About Ab Initio Training

Techie Zone is a leader in Providing Ab Initio Training Courses located in BTM Layout, Bangalore based on real-time scenarios and placement oriented topics. Our Ab Initio training course covers basic to advanced levels. Our team consists of highly qualified and certified trainers who are working professionals with hands on real time Ab Initio projects knowledge. This  which will provide you an edge over other training institutes.

We provide certification training programs in Ab Initio Training. We have successfully trained and provided placement for many of our students in major MNC Companies, after successful completion of the course. We provide placement support for our students. Our Ab Initio training center is well equipped with lab facilities and excellent infrastructure for providing you real time training experience.

Techie Zone provides regular training classes(day time classes), weekend training classes, and fast track training classes for Ab Initio Training in our Training Centers located in BTM Layout, Bangalore. Students can Enroll and start attending classes as well as practice sessions in the labs without effecting their regular college or office work. We also provide Online Training Classes for Ab Initio Training Course.

Our team of experts at Techie Zone Training Institute, Bangalore have designed our Ab Initio Training course content and syllabus based on students requirements to achieve everyone's career goal.  Our Ab Initio Training course fee is economical and tailor-made based on training requirement.
 
Contact us today to schedule a free demo and complete course details on Ab Initio Training Course.


Ab Initio Training Course Content

Ab initio training course content and Syllabus

Abinitio Course Contents

  • Introduction to Abinitio
  • Abinitio Architecture
  • Graph Programming
  • Introduction to .dat and .dml files

Partition Components:

  • Braod Cast
  • Partition by Expression
  • partition by range
  • partition by community
  • partition by percentage
  • partition by Round Robin

Departition Components:

  • Concatenate
  • Gather
  • Interleave
  • Merge


Multifile System(MFS):
  • Types of parallelism:
  • Layouts:
  • Sort Components:
  • Sort
  • Sort with in groups
  • Sample
  • Partition by key and sort

Transform Components:

  • Filter by expression
  • Aggregate
  • Scan
  • Rollup
  • Denormalize Sorted
  • Normalize
  • Reformat
  • Match sorted
  • Dedup sorted
  • Working with Databases

Database components:

  • Run SQL
  • Input Table
  • Output Table
  • Truncate Table
  • Update table

Phase and check Points:
Miscellaneous component:

  • Gather logs
  • Run program
  • Redefine format
  • Trash
  • Replicate

Dataset Components:

  • Input File
  • Output File
  • Lookup File
  • Intermediate File

FTP Components:

  • FTP From
  • FTP To

Compress Components:

  • Compress
  • Uncompress
  • Gzip
  • Gunzip

Validate Component:

  • Check Order
  • Generate Records
  • Generate Random bytes
  • Compare Records
  • Compute Check Sum
  • Compare Check Sum


Translate components:

  • Record XML
  • Write XML
Project and Sandbox:



Reviews for Ab Initio Training Course

No Reviews for this Course Yet.. Be the First to Review?

Interview Questions

1.      What is a Web service? What is a Web service?

2.      What kind of services operating system provides? What kind of services operating system provides?

3.      What is logic? What is logic?

4.      What is algorithm? What is algorithm?

5.      What is constant? What is constant?

6.      What is variable? What is variable?

7.      What for an assignment statement is used? What for an assignment statement is used?

8.      What are the four basic types of data? What are the four basic types of data?

9.      What for a conditional loop is best suited? What for a conditional loop is best suited?

10.   What for an incremented loop is best suited? What for an incremented loop is best suited?

11.   What is Relational operators used for? What is Relational operators used for?

12.   What Relational Operators Do you know? (C) What Relational Operators Do you know? (C)

13.   What does grep() stand for? (Unix interview question) What does grep() stand for? (Unix interview question)

14.   What does RPG stand for? What does RPG stand for?

15.   What does RPG stand for? What does RPG stand for?

16.   What does Lisp stand for? What does Lisp stand for?

17.   What does HTML stand for? . What does HTML stand for?

18.   What does Fortran stand for? What does Fortran stand for?

19.   What does DOS stand for? What does DOS stand for?

20.   What does CGI stand for? What does CGI stand for?

21.   What does CORBA stand for? What does CORBA stand for?

22.   What does Cobol stand for? What does Cobol stand for?

23.   What does Case stand for? What does Case stand for?

24.   What does BASIC stand for? What does BASIC stand for?

25.   What does ASCII stand for? What does ASCII stand for?

26.   What does Algol stand for? What does Algol stand for?

27.   What does SQL stand for? What does SQL stand for?

28.   What is the latest version that is available in Ab-initio?

29.   How to take the input data from an excel sheet?

30.   How will you test a dbc file from command prompt ?

31.   Which one is faster for processing fixed length dmls or delimited dmls and why ?

32.   What are the contineous components in Abinitio?

33.   What is meant by fancing in abinitio ?

34.   What is the relation between EME , GDE and Co-operating system ?

35.   What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summirize group of data record. then where we will use aggregation ?

36.   Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data.

37.   Explain the difference between the ?truncate? and “delete” commands.

38.   When running a stored procedure definition script how would you guarantee the definition could be “rolled back” in the event of problems.

39.   Describe the ?Grant/Revoke? DDL facility and how it is implemented.

40.   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).

41.   What is the difference between a DB config and a CFG file?

42.   What about DML changes dynamically?

43.   What is backward compatibility in abinitio?

44.   What are kinds of layouts does ab initio supports?

45.   How do you add default rules in transformer?

46.   Have you used rollup component? Describe how.

47.   What are primary keys and foreign keys?

48.   What is an outer join?

49.   What are Cartesian joins?

50.   What is the purpose of having stored procedures in a database?

51.   What is a cursor? Within a cursor, how would you update fields on the row just fetched?

52.   How would you find out whether a SQL query is using the indices you expect?

53.   How can you force the optimizer to use a particular index?

54.   When using multiple DML statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why.?

55.   Describe the elements you would review to ensure multiple scheduled “batch” jobs do not “collide” with each other.

56.   What is semi-join?

57.   How to get DML using Utilities in UNIX?

58.   What is driving port? When do you use it?

59.   What is local and formal parameter?

60.   What is BRODCASTING and REPLICATE ?

61.   Explain what is lookup?

62.   Have you worked with packages?

63.   How to create repository in abinitio for stand alone system(LOCAL NT)?

64.   What is the difference between .dbc and .cfg file?

65.   What does dependency analysis mean in Ab Initio?

66.   What do you have to give the value for the Record Required parameter for a natural join?

67.   When do you use Partition by Expression?

68.   What is Adhoc File System? Give me a scenario where you used it?

69.   What are the different commands that you used when writing wrappers?

70.   What do the hidden files in a sandbox represent and what does start.ksh represent?

71.   How can we test the abintio manually and automation?

72.   What is the difference between sandbox and EME, can we perform checkin and checkout through sandbox/ Can anybody explain checkin and checkout?

73.   What does layout means in terms of Ab Initio?

74.   What are different things that you have to consider when loading data into a table?

75.   How to Create Surrogate Key using Ab Initio?

76.   Can anyone give me an exaple of realtime start script in the graph?

77.   What are differences between different GDE versions(1.10,1.11,1.12,1.13and 1.15)? What are differences between different versions of Co-op?

78.   Do you know what a local lookup is?

79.   How many components in your most complicated graph?

80.   How to handle if DML changes dynamically in abinitio?

81.   Explain what is lookup?

82.   Have you worked with packages?

83.   How to run the graph without GDE?

84.   What are the different versions and releases of ABinitio (GDE and Co-op version)?

85.   What is the Difference between DML Expression and XFR Expression ?

86.   How Does MAXCORE works?

87.   What is $mpjret? Where it is used in ab-initio?

88.   How do you convert 4-way MFS to 8-way mfs?

89.   What is skew and skew measurement?

90.   What is the importance of EME in abinitio?

91.   How do you add default rules in transformer?

92.   What is difference between file and table in abinitio?

93.   How to create a computer program that computes the monthly interest charge on a credit card account?

94.   What is .abinitiorc and What it contain?

95.   What do you mean by .profile in Abinitio and what does it contains?

96.   What is data mapping and data modelling?

97.   What is the difference between partitioning with key and round robin?

98.   Can anyone tell me what happens when the graph run? i.e The Co-operating System will be at the host, We are running the graph at some other place. How would you do performance tuning for already built graph ? Can you let me know some examples?

99.   How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?

100.                    What are the most commonly used components in a Abinition graph? can anybody give me a practical example of a trasformation of data, say customer data in a credit card company into meaningful output based on business rules?

101.                    Can we load multiple files?

102.                    Can anyone please explain the environment varaibles with example.?

103.                    Explain the differences between api and utility mode?

104.                    Please let me know whether we have ab initio GDE version 1.14 and what is the latest GDE version and Co-op version?

105.                    What are the Graph parameter?

106.                    How to find the number of arguments defined in graph.?

107.                    What is the difference between rollup and scan?

108.                    How to work with parameterized graphs?

109.                    Please give us insight on Enterprise Meta Environment, and some possible questions on that.?

110.                    What are delta table and master table?

111.                    What error would you get when you use Partition by Round Robin and Join?

112.                    Do you know what a local lookup is?

113.                    How many components in your most complicated graph?

114.                    How to handle if DML changes dynamically in abinitio?

115.                    How do you count the number of records in a flat file?

116.                    How do you connect EME to Abinitio Server?

117.                    What is the difference between a DB config and a CFG file?

118.                    Do you know what a local lookup is?

119.                    What is the difference between look-up file and look-up, with a relevant example?

120.                    Have you worked with packages?

121.                    In which scenarios would you use Partition by Key and also, Partition by Round Robin and differences between the both?

122.                    What are the different dimension tables that you used and some columns in the fact table?

123.                    What is the difference between a Scan component and a RollUp component?

124.                    How do we handle if DML changing dynamicaly?

125.                    What is m_dump?

126.                    What is the syntax of m_dump command?

127.                    Have you used rollup component? Describe how.?

128.                    How do you improve the performance of a graph?

129.                    How many components are there in your most complicated graph?

130.                    What is the function you would use to transfer a string into a decimal?

131.                    For data parallelism, we can use partition components. For component parallelism, we can use replicate component. Like this which component(s) can we use for pipeline parallelism?

132.                    What is AB_LOCAL expression where do you use it in ab-initio?

133.                    What is mean by Co > Operating system and why it is special for Ab-initio ?

134.                    How to retrive data from database to source in that case whice componenet is used for this?

135.                    How can you run a graph infinitely?

136.                    What is the syntax of m_dump command?

137.                    How to do we run sequences of jobs ,, like output of A JOB is Input to B How do we co-ordinate the jobs?

138.                    How do you truncate a table?

139.                    What is a ramp limit?

140.                    What is the difference between dbc and cfg? When do you use these two?

141.                    What are the compilation errors you came across while executing your graphs?

142.                    What is depth_error?

143.                    Difference between conventional loading and direct loading ? When it is used in real time .?

144.                    During the execution of graph, let us say you lost the network connection, would you have to start the process all over again or does it start from where it stopped?

145.                    What are the different types of partitions and scenarios.?

146.                    What does dependency analysis mean in Ab Initio?

147.                    What does unused port in join component do?

148.                    Define Multi file system. Can you create multifile system on the same server? Also, if you have a table that has Name, Address, Status, Position attributes, can Name and Address be on one partition and Status and Position in the other partition?

149.                    What is a sandbox? Did the co-operating system version 2.8 have sandbox, if not how would you store the respective files?

150.                    How did you do version control? Which tool did you use?

151.                    How do you troubleshoot performance issues in graph?

152.                    What are the usual errors that you encounter during ETL process apart from compilation process?

153.                    Were you involved in production support? What were the different kinds of problems that you encountered?

154.                    How do you count the number of records in a multifile system without using GDE?

155.                    What does Scan and Rollup component do and give a scenario where you used them?

156.

Quick Contact