Please enable JavaScript.
Coggle requires JavaScript to display documents.
Talend interview - Coggle Diagram
Talend interview
Datawarehouse
Scd
Type 2
Complete history
From dt
To dt
Status
Type 1
Overwrite
Type 3
Previous history
No additional records
Columns
Previous val
Current val
Updated dt
Snow flake vs star
Elt vs etl
Dimensions
Described facts
Text
Types
Junk
SCD & RCD
Inferred
Conformed
Shared multiple facts
Sungle primary key
Bridge
Integrity
Degenerate
Role playing
Shrunkers
Static
Facts
Numbers
Aggregate dim
Types
Additive
Non additive
Semi additive
Redshift
Columnar storage
Hdfs
Normal sql
Normalization
1nf
Primary key all records
2nf
Bridge table
Attributes key dep
3nf
Rest api
Api
Crud
Create post
Read get
Update put
Delete
Request
Url
Response
Json/xml
Talend tool
Data quality
Masking
Data cleansing
Stewardship
Data processing
Taggregate row
Groupby
Aggregate
Sum
Count
Count distinct
Taggregatesortedrow
Sort before passing to this comp
Tflowiterate
Titerateflow
Trestapi
Get
Post
Trestrequest
Url
Trestresponse
Elt vs etl
Tmap
Join model
Left
Inner join
Matchmodel
First match
Unique
Last match
Lookup model
Load once
Default
Reload at each row
Reload at each row cache
Db
Oracle
Oracle row
Connection
Input output
Salesforce
Connection
Input
Bulk
Sql
Ddl
Create
Insert
Insert into table name columbs() values()
Alter
Dml
Delete
Update
In
Others
Desc
Ind
Index
Create index sid on tablename(column)
Create function
Select myfunction
Create procedure
Big data
Hive
Table types
External
Schem in ctrl
Managed
Data
Schema
Tbl properties
Custom serde
Default location hdfs://namenode_server/hive/warehouse
Not for oltp
Commands
Rename
Alter table table_name replace column
Alter table table_name rename table_new
Source path/k.hql
Metastore
Schema
Database
Partition
Features
Mode of run
Local
Distributed
Sudodistributed
Datatype
Timestamp
Collection
Array
Map
Struct
Unix comm !
Hive variable
.hiverc
Hdfs
Java
Routine
JMS Api
Publisher
Reciever
MQ
Ibm websphere mq