-
Notifications
You must be signed in to change notification settings - Fork 0
/
Parameters.cfg
64 lines (57 loc) · 1.63 KB
/
Parameters.cfg
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
#Source
Schema_name="DBO"
#jdbs_connection="jdbc:oracle:thin:@//localhost:1521"
#server_name=servername
############################### Sqoop job parameters ##################################
Script_Location=/Sqoop
#Username=masteruser
#PassWord=Sqoop_Passwords.pwd
Meta_mappers=10
Numofmappers=4
Meta_File_delimiter="|"
Data_File_delimiter=^A
Record_Delimiter="^B"
#Table_name="CUST"
#$query=""
############################### paths #################################################3
Landing_Location=/Sqoop/Data_Files
Sqoop_Landing_Location=/Sqoop/Data_Files
Table_list=Table_list
Meta=Meta
Data=Data
Ctl=Ctl
Log=Log
in_bound_location=/nbound
############################################ctrl file parameters##################################################
Source_name=SourceName
Source_schema_name=SourceSchemaName
Entity_name=EntityName
Record_count=RecordCount
Extract_date=ExtractDate
Extract_time=ExtractTime
File_time_stamp=FileTimeStamp
Extract_date_time=ExtractDateTime
ETL_landing_directory=ETLLandingDirectory
File_load_type=FileLoadType
Source_time_zone=SourceTimeZone
Effective_date=EffectiveDate
Data_file_extension=DataFileExtension
Additional_files_extensions=AdditionalFilesExtensions
File_format_type=FileFormatType
Source_watermark_1=SourceWatermark_1
Source_watermark_2=SourceWatermark_2
ETL_process=ETLProcess
frequency=Frequency
Record_delimiter=RecordDelimiter
RecordDelimiter1='\n'
Field_delimiter=FieldDelimiter
FieldDelimiter="|"
FileLoadType=FULL
ETLAppUserId=etluser
ExtractStatus=Success
DataFileExtension=.dat
metaFileExtension=.meta
ctlFileExtension=.ctl
FileFormatType=delimited
ETLProcess=pull
Frequency_type=daily