Home
Videos uploaded by user “Informatica”
Informatica parameter file
 
08:56
Informatica parameters and variables are used to minimize hard-coding in ETL, thereby increasing flexibility, reusability, readabilty and avoides rework by changing the values in the ETL Parameter files provide us with the flexibility to change parameter and variable values every time we run a session or workflow with out touching the mapping A parameter file contains two sections: 1. Heading section: It is to identify the integration service, folder, workflow, worklet, session to which the parameters or variables apply 2. Definition Section This section contains list of parameters and variables with their assigned values
Views: 50356 Informatica
Informatica Repository and Integration service creation
 
03:20
Creation of an Informatica repository and integration service
Views: 11871 Informatica
Command task in Informatica
 
13:09
Command task in Informatica is used to run the shell / unix commands during the workflow. We can specify unix commands in the command task to remove rejected files, ftp files, creating files, copy a file, rename a file and archive a file etc.
Views: 35246 Informatica
Informatica mapping,session and workflow creation
 
10:31
This video will explain how to create an Informatica mapping, session and workflow. This will also explains an ETL functionality, how to take connections, verifying the session log and bad file.
Views: 11166 Informatica
How to download Informatica Power center 9.6.1
 
06:08
This video tells how and where to download Informatica power center 9.6.1. And steps to extract the zip files and files to be installed.
Views: 9161 Informatica
Informatica Database Connection Parameterization
 
15:02
Parametrizing database connections in Informatica. https://www.youtube.com/c/informaticaETL
Views: 5605 Informatica
Update records with out update strategy in Informatica
 
09:06
This video will explain how to insert or update a record into a target table with out using update strategy transformation Draback: Using update strategy we can inactive an existing record and insert a new record. With the above approach(with out update strategy) we can not inactive an existing record based on an incoming record from source however we can update an existing one and insert a new one
Views: 31981 Informatica
Flat file source in Informatica
 
08:35
This video will explain how to load a sample flat file data into a table using Informatica transformation
Views: 18858 Informatica
Performance Tuning of Informatica part2
 
07:57
Performance tuning tips https://www.youtube.com/c/informaticaETL
Views: 6083 Informatica
Performance Tuning of Informatica part1
 
13:56
Identifying major bottlenecks in Informatica and fixing them.
Views: 15296 Informatica
List file in Informatica
 
13:56
Views: 5493 Informatica
Rank Transformation in Informatica
 
08:01
Using rank transformation we are retrieving first and last record from a table
Views: 4958 Informatica
Convert source single row into target multiple rows
 
08:43
With out normalizer transformation we are converting source row into target columns
Views: 14592 Informatica
Dynamic data masking SQL Server 2016
 
13:00
This video tells how data masking works in SQL Server 2016
Views: 3434 Informatica
Reasons for rejected records in Informatica
 
10:35
This video will explain reasons for records getting rejected in Informatica Where we can see these rejected records and its bad file And a simple example it explains one of the cause for rejection in informatica Reasons for rejected records: When there are data base constraints Update strategy contains dd_reject Non compatible data flow into target transformation (Ex: source has char, target has int)
Views: 10097 Informatica
Informatica transformation types
 
10:30
This video will describes types of Informatica transformations. And why a transformation is called an active or passive transformation
Views: 8601 Informatica
XML Source Qualifier Transformation in Informatica
 
15:02
This video tells how to use XML source qualifier transformation in Informatica. You can see the continuation in XML Generator Transformation in Informatica. https://www.youtube.com/c/informaticaETL
Views: 14437 Informatica
Dynamic Filenames in Informatica
 
13:39
In this video we will see generation of target files with dynamic names.
Views: 22699 Informatica
Informatica pre and post sql
 
10:36
Pre-Post SQL properties of source qualifier transformation Pre SQL: The SQL query fires initially when loading to that database. Post SQL: The SQL query fires at the end i.e., after loading the records to the database. Pre and Post SQL to execute SQL statement like Insert, Update, Delete before and after the load. pre SQL means " SQL statement executed using the source connection,before a pipeline is run" and post SQL means " SQL statement executed using the source connection,after a pipeline is run".
Views: 17647 Informatica
Separating duplicate and non duplicate rows
 
10:40
This video will explain how to segregate the duplicate and distinct rows from source table to separate target tables
Views: 24205 Informatica
XML Generator Transformation in Informatica
 
11:44
This video tells how to generate xml file from RDBMS source. And it is a continuation of XML Source Qualifier Transformation in Informatica video. https://www.youtube.com/c/informaticaETL
Views: 3578 Informatica
Normalization
 
15:00
Views: 1325 Informatica
Dynamic SQL Transformation In Informatica
 
13:54
In Dynamic SQL transformation, integration service prepares the query for each input row and then runs the query.
Views: 6631 Informatica
Type2 Dimension Part1
 
15:02
It describes implementation of Type2 dimension.
Views: 454 Informatica
Static SQL Transformation In Informatica 1
 
15:02
In Static Sql transformation, integration service runs the query once and runs the same query for all the input rows.
Views: 8558 Informatica
Sequence Generator in Informatica
 
12:26
The Sequence Generator transformation generates numeric values. Using this transformation we can create unique primary key values, replace missing primary keys, or cycle through a sequential range of numbers.
Views: 19912 Informatica
How to do a table clean up in SQL Server
 
15:02
How to clean up a table in SQL Server
Views: 2490 Informatica
Informatica flat file load
 
08:29
This video will explain how to load a flat file using Informatica mapping
Views: 2509 Informatica
Updating records using update strategy transformation_Part1
 
15:02
Update strategy transformation is an active and connected transformation. Update strategy transformation is used to insert, update, and delete records in the target table. It can also reject the records without reaching the target table.
Views: 37347 Informatica
Informatica look up is active  transformation
 
04:22
This video will describe why a look up transformation is an active in informatica 9.1
Views: 2905 Informatica
columns spliting in Informatica
 
12:44
Interview question: Split the non-key columns to separate tables with key column in both the tables
Views: 1443 Informatica
Updating records using update strategy transformation_Part2
 
09:12
Update strategy transformation is an active and connected transformation. Update strategy transformation is used to insert, update, and delete records in the target table. It can also reject the records without reaching the target table.
Views: 12353 Informatica
Stored Procedure Transformation In Informatica Part3
 
09:54
Stored procedure transformation in informatica with table return type. https://www.youtube.com/c/informaticaETL
Views: 908 Informatica
SQL Server System Databases 2016
 
11:42
SQL Server System Databases and its purpose
Views: 172 Informatica
Stored Procedure Transformation In Informatica Part1
 
15:02
Stored Procedure Transformation is a passive transformation, can be used in both connected and unconnected mode, more details in video... www.youtube.com/c/informaticaETL
Views: 2819 Informatica
Aggregator Transformation
 
11:22
Views: 5104 Informatica
Informatica 9.6.1 Sever Installation
 
14:42
This video explains how to install Informatica 9.6.1 Server and details required to set up database connection.
Views: 2990 Informatica
Informatica Introduction
 
04:53
This video describes Informatica's tool major four components functionality i.e, Power center Designer Repository Monitor and workflow manager
Views: 3378 Informatica
xp_cmdshell in sql server
 
10:25
Using Xp_Cmdshell stored procedure, we can create user defined file formats by copying bulk copies of data from sql server like sql select statements and also we can display string related content as an output
Views: 10074 Informatica
Static SQL Transformation In Informatica 2
 
12:41
In Static Sql transformation, integration service runs the query once and runs the same query for all the input rows.
Views: 4078 Informatica
Jbs karimnagar stop
 
00:43
Very few buses in jbs stop on 31st dec 2011.
Views: 387 Informatica
SQL Server Column Store Index Part 1
 
15:02
This video provides details about SQL Server column store index.
Views: 157 Informatica
COL_LENGTH In SQL Server
 
09:09
Col length function in SQL Server
Views: 165 Informatica
SQL Server Interview Questions Part 2
 
13:08
Interview Questions Part 2 - Query to get same data from multiple columns and show the Result
Views: 254 Informatica
COALESCE and ISNULL In SQL Server
 
15:02
COALESCE and ISNULL function returns first non NULL value - SQL Server
Views: 772 Informatica
Sql Server Isolation levels Part1
 
15:02
This video tells isolation levels in MS SQL Server
Views: 502 Informatica
How to save internet data in windows 10
 
10:34
Is windows eating your internet? Then its time to change your windows settings. Check out the configurations here https://youtu.be/x17NXHBZbpw
Views: 61 Informatica