Informatica Interview
Informatica Interview
  • 20
  • 208 114
Informatica PowerCenter Components
If you’ve enjoyed this video. Like and Subscribe to my channel for more similar informatica interview videos and tutorials.
Got any questions about informatica interview? Ask me in the comment section below.
------------------------------
Why should you watch my channel?
Informatica is the market leader in the ETL segment. I am working as senior ETL developer for 10+ years in North Carolina, USA and want to help and share realtime and scenario based tutorial to prepare for interview.
Who should watch this video?
If you are fresher or already working but looking to refresh SQL, Informatica, ETL, Data warehousing concepts for interview.
For more Information:
Please visit my other platforms.
Website: www.informaticainterview.com
LinkedIn: www.linkedin.com/in/informatica-interview-prep
Or contact me by email: informaticainterviewhelp@gmail.com
zhlédnutí: 557

Video

SQL Aliases4:18SQL Aliases
SQL Aliases
zhlédnutí 402Před 3 lety
SQL aliases are used to give a table, or a column in a table, a temporary name. Aliases are often used to make column names more readable. An alias only exists for the duration of the query.
Data warehouse - star schema, snowflake schema and galaxy schema53:59Data warehouse - star schema, snowflake schema and galaxy schema
Data warehouse - star schema, snowflake schema and galaxy schema
zhlédnutí 3,5KPřed 3 lety
If you’ve enjoyed this video. Like and Subscribe to my channel for more similar informatica interview videos and tutorials. Got any questions about informatica interview? Ask me in the comment section below. Why should you watch my channel? Informatica is the market leader in the ETL segment. I am working as senior ETL developer for 10 years in North Carolina, USA and want to help and share rea...
SQL wildcard character example7:00SQL wildcard character example
SQL wildcard character example
zhlédnutí 7KPřed 3 lety
In SQL, wildcard characters are used with the SQL LIKE operator. SQL wildcards are used to search for data within a table. % A substitute for zero or more characters _ A substitute for a single character [charlist] Sets and ranges of characters to match [^charlist] or [!charlist]
Data warehouse details on Fact & Dimension48:56Data warehouse details on Fact & Dimension
Data warehouse details on Fact & Dimension
zhlédnutí 492Před 3 lety
If you’ve enjoyed this video. Like and Subscribe to my channel for more similar informatica interview videos and tutorials. Got any questions about informatica interview? Ask me in the comment section below. Why should you watch my channel? Informatica is the market leader in the ETL segment. I am working as senior ETL developer for 10 years in North Carolina, USA and want to help and share rea...
Data warehouse Principles - Subject Oriented, Integrated, non-volatile, time variant51:20Data warehouse Principles - Subject Oriented, Integrated, non-volatile, time variant
Data warehouse Principles - Subject Oriented, Integrated, non-volatile, time variant
zhlédnutí 1,3KPřed 3 lety
If you’ve enjoyed this video. Like and Subscribe to my channel for more similar informatica interview videos and tutorials. Got any questions about informatica interview? Ask me in the comment section below. Why should you watch my channel? Informatica is the market leader in the ETL segment. I am working as senior ETL developer for 10 years in North Carolina, USA and want to help and share rea...
Learn SQL Commands - Create table, Insert into, Alter table, Delete table, Drop table6:39Learn SQL Commands - Create table, Insert into, Alter table, Delete table, Drop table
Learn SQL Commands - Create table, Insert into, Alter table, Delete table, Drop table
zhlédnutí 1,8KPřed 3 lety
If you’ve enjoyed this video. Like and Subscribe to my channel for more similar informatica interview videos and tutorials. Got any questions about informatica interview? Ask me in the comment section below. Why should you watch my channel? Informatica is the market leader in the ETL segment. I am working as senior ETL developer for 10 years in North Carolina, USA and want to help and share rea...
Data Warehousing cycle - complete guide59:10Data Warehousing cycle - complete guide
Data Warehousing cycle - complete guide
zhlédnutí 236Před 3 lety
If you’ve enjoyed this video. Like and Subscribe to my channel for more similar informatica interview videos and tutorials. Got any questions about informatica interview? Ask me in the comment section below. Why should you watch my channel? Informatica is the market leader in the ETL segment. I am working as senior ETL developer for 10 years in North Carolina, USA and want to help and share rea...
What is RDBMS? -Learn SQL, Data warehousing for beginners.4:29What is RDBMS? -Learn SQL, Data warehousing for beginners.
What is RDBMS? -Learn SQL, Data warehousing for beginners.
zhlédnutí 509Před 3 lety
About RDBMS. If you’ve enjoyed this video. Like and Subscribe to my channel for more similar informatica interview videos and tutorials. Got any questions about informatica interview? Ask me in the comment section below. Why should you watch my channel? Informatica is the market leader in the ETL segment. I am working as senior ETL developer for 10 years in North Carolina, USA and want to help ...
Learn important SQL Commands6:10Learn important SQL Commands
Learn important SQL Commands
zhlédnutí 103Před 3 lety
Important SQL Commands, Select, update, delete... If you’ve enjoyed this video. Like and Subscribe to my channel for more similar informatica interview videos and tutorials. Got any questions about informatica interview? Ask me in the comment section below. Why should you watch my channel? Informatica is the market leader in the ETL segment. I am working as senior ETL developer for 10 years in ...
Basic of Informatica Architecture for beginners -139:32Basic of Informatica Architecture for beginners -1
Basic of Informatica Architecture for beginners -1
zhlédnutí 960Před 3 lety
Informatica Domain - It is an administrative unit consisting of nodes and services. These nodes and services can be further categorized into folders and subfolders. There are basically two types of services in the Informatica Domain- Service Manager and Application Services you’ll be learning in Informatica server Architecture tutorial. While the former is responsible for authenticating/authori...
SQL- DDL Command and Syntax5:45SQL- DDL Command and Syntax
SQL- DDL Command and Syntax
zhlédnutí 265Před 3 lety
DDL(Data Definition Language) : DDL or Data Definition Language actually consists of the SQL commands that can be used to define the database schema. It simply deals with descriptions of the database schema and is used to create and modify the structure of database objects in the database. Examples of DDL commands: CREATE - is used to create the database or its objects (like table, index, funct...
SQL- DML Command and Syntax7:06SQL- DML Command and Syntax
SQL- DML Command and Syntax
zhlédnutí 319Před 3 lety
DML(Data Manipulation Language) : The SQL commands that deals with the manipulation of data present in the database belong to DML or Data Manipulation Language and this includes most of the SQL statements. Examples of DML: INSERT - is used to insert data into a table. UPDATE - is used to update existing data within a table. DELETE - is used to delete records from a database table. If you’ve enj...
Star and SnowFlake Schema in Data Warehouse9:20Star and SnowFlake Schema in Data Warehouse
Star and SnowFlake Schema in Data Warehouse
zhlédnutí 60KPřed 3 lety
What is a Star Schema? In the STAR Schema, the center of the star can have one fact table and a number of associated dimension tables. It is known as star schema as its structure resembles a star. The star schema is the simplest type of Data Warehouse schema. It is also known as Star Join Schema and is optimized for querying large data sets. What is a Snowflake Schema? SNOWFLAKE SCHEMA is a log...
Learn SQL Commands DDL DML DCL TCL5:40Learn SQL Commands DDL DML DCL TCL
Learn SQL Commands DDL DML DCL TCL
zhlédnutí 556Před 3 lety
DDL DDL is short name of Data Definition Language, which deals with database schemas and descriptions, of how the data should reside in the database. CREATE - to create database and its objects like (table, index, views, store procedure, function and triggers) ALTER - alters the structure of the existing database DROP - delete objects from the database TRUNCATE - remove all records from a table...
What is SQL? [understand in 4.5 minutes for beginners]4:27What is SQL? [understand in 4.5 minutes for beginners]
What is SQL? [understand in 4.5 minutes for beginners]
zhlédnutí 103Před 3 lety
What is SQL? [understand in 4.5 minutes for beginners]
Difference Between Fact Table and Dimension Table - Interview questions7:25Difference Between Fact Table and Dimension Table - Interview questions
Difference Between Fact Table and Dimension Table - Interview questions
zhlédnutí 124KPřed 3 lety
Difference Between Fact Table and Dimension Table - Interview questions
How is data mart different from data warehouse?6:32How is data mart different from data warehouse?
How is data mart different from data warehouse?
zhlédnutí 3,5KPřed 3 lety
How is data mart different from data warehouse?
OLTP vs OLAP7:45OLTP vs OLAP
OLTP vs OLAP
zhlédnutí 1,6KPřed 4 lety
OLTP vs OLAP
what is ETL? - Informatica developer interview question.3:37what is ETL? - Informatica developer interview question.
what is ETL? - Informatica developer interview question.
zhlédnutí 873Před 4 lety
what is ETL? - Informatica developer interview question.

Komentáře