Subcribe and Access : 5200+ FREE Videos and 21+ Subjects Like CRT, SoftSkills, JAVA, Hadoop, Microsoft .NET, Testing Tools etc..

Batch Date: Feb 5th @8:00AM

Faculty: Mrs. Y. Laxmi (5+ Yrs of Exp,.. & Real Time Expert)

Duration: 45 Days

Venue :
DURGA SOFTWARE SOLUTIONS,
Flat No : 202, 2nd Floor,
HUDA Maitrivanam,
Ameerpet, Hyderabad - 500038

Ph.No: +91- 9246212143, 80 96 96 96 96

Syllabus:

ETL DEVELOPER

ETL Components

1. Tsort row
2. Tunite
3. Tunique row
4. Tbuffer input
5. TBuffer Output
6. THash Input
7. THash Output
8. Tfilelist
9. Tfile Input Delimited
10. Tfile Output Delimited
11. Tsend Mail
12. Treplicate
13. Tfilter Columns
14. Tfilter Rows
15. Tflow iterate
16. Titerate To Flow
17. Tconvert Type
18. Tdie
19. Tcontext Load
20. Tcontext Dump
21. TRowGenetor
22. Pre Job
23. Post Job
24. Tsample Rows
25. Tnormalise
26. Tdenormalise
27. Tmap
28. Taggrigator
29. Tjoin
30. Tsystem
31. Tjava
32. Tjavarow
33. Tjavaflex
34. TschemaComlienceCheck
35. Tlogrow
36. Tlogcatcher
37. Trest
38. TrestClient
39. Tloop
40. Tsoap
41. Tinfiniteloop
42. Tsleep
43. tset global variable
44. Textract Delimited Fields
45. TFilerowcount
46. Trun job
47. TSSH
48. Tstartcatcher

FILE_PROCESSING_COMPONENTS

49. Tfilecopy
50. Tfilearchive
51. TfileProperties
52. Tfileunarchive
53. Tfiletouch
54. tfiledelete
55. tfileexist
56. TWait for file

FTP Components

57. Tftpput
58. tftpget
59. tftpdelete
60. tftpfileexist
61. tftpconnection
62. tftprename
63. tftplist
64. tftp truncate
65. tftp rename
66. tftp close
67. tftpfileproperties

Database_Components

68. TOracle input
69. TOracle Output
70. tOraclerow
71. tOracleconnection
72. tOracleoutputBulkexecu
73. tOracleBulkexec
74. tOracleclose
75. tOracleRollback
76. tOraclecommit

Links

78. Onsubjobok
79. runif
80. oncomponent ok
81. on component error
82. Joblet
83. onsubjoberror

Types of File Formats

84. tExcelinput
85. tExceloutput
86. tfileinput json
87. tfileoutput json
88. tfile input xml
89. tfile output xml
90. tfile input positional
91. tfile output positional

DB CONCEPTS

92. Dimension jobs and fact jobs
93. StarSchema-Snowflake Schema
94. SCD Type I
95. SCD Type II
96. SCD Type III
97. Project explanation