Videos uploaded by user “Mandar Gogate”
Indirect File Loading And Dynamic File Creation Using Transaction Control Transformation
This video will help to understand, how to read different files [having same structure] using only one source qualifier with the help of Indirect File Loading method. Also, it will help to understand, how to create files dynamically with the help of Transaction Control Transformation.
Views: 16654 Mandar Gogate
Informatica : Lookup Tranformation - PassAllMatchingRows
Lookup as Active transformation with feature as "Pass All Matching Rows"
Views: 11183 Mandar Gogate
Informatica : Static Lookup Persistent Cache Files
Informatica Static Lookup Tranformation With Enabling Persistent Cache Option
Views: 16311 Mandar Gogate
SSIS : Script Component
How to use Script Component in SSIS; which mostly similar to Java Transformation in Informatica.
Views: 8286 Mandar Gogate
Informatica : Using PMCMD To Run Informatica Workflow.avi
How to run informatica workflow using pmcmd command from command line. Please view this video in full screen mode for better clearity.
Views: 36526 Mandar Gogate
Informatica : XML Generator Tranformation
How to create xml files as an output using XML Generator Tranformation in Informatica.
Views: 24466 Mandar Gogate
Informatica : Mapping and Workflow Variable Value Assignments
1, How to assign value to a mapping variable 2. how to pass value of one mapping variable in one session to another mapping variable in separate session
Views: 63079 Mandar Gogate
Informatica : Session dependencies using Workflet
How to setup dependencies between different loads using Informatica Worklet.
Views: 4250 Mandar Gogate
Informatica : Interview Question [Scenario Based]
How to transform source files to required format in output file using Indirect Loading and Java Transformation
Views: 13239 Mandar Gogate
Informatica : Event Wait Tasks - File Watcher
How to use pre-defined event wait task as a file watcher ?
Views: 9448 Mandar Gogate
Informatica : Using Oracle External Loader Utility In Informatica for Relational Target Loading
Informatica External Loader utility as Oracle Target.. Please view this video in full screen mode
Views: 7228 Mandar Gogate
Informatica : OracleSequenceGenerator
How to use Oracle Sequence in Informatica mapping instead of using Informatica Sequence Generator Tranformation.
Views: 3828 Mandar Gogate
Informatica : Minus Operation On Flat Files.avi
How to perform Minus Operation on flat file using informatica
Views: 4514 Mandar Gogate
Informatica : Static Look Cache Sharing - Un-Named and Named Cache
How Informatica Integration Service shares static lookup cache in same / different mappings in same / different target load order group?
Views: 4640 Mandar Gogate
Stored Procedure Call From SQ Transformation
Why to call Stored Proc from SQ Transformation instead of Stored Procedure Transformation In Informatica
Views: 1779 Mandar Gogate
Informatica : Partitioning Basic Example - Part 1
Basic Example of Partitioning In Informatica
Views: 54197 Mandar Gogate
Informatica : Incremental Aggregation
Incremental Aggregation Implementation At Informatica
Views: 9307 Mandar Gogate
Informatica : XML View Creation
How and When to create an Informatica XML View while importing an XML source file. Please find the xml source file at -- http://gogates.blogspot.in/2013/04/informatica-xml-source-file.html
Views: 5932 Mandar Gogate
Informatica : XML Source.avi
Working with XML as a source and loading a data into relational target. Please find the xml file at http://gogates.blogspot.in/2013/04/informatica-xml-source-file.html
Views: 36202 Mandar Gogate
Informatica : XML Parser Tranformation
How to parse xml records using XML Parser tranformation?
Views: 19376 Mandar Gogate
Informatica : Backup And Restoring Repository Contents
How will you copy the content of one Infra repository to another Infra repository? How can you take a backup and Restore it ?
Views: 6974 Mandar Gogate
Informatica : Indirect File Load With Different File Structure
Loading more than once file having different structure to one target using only one source qualifier. We will define these source file structure in Field_Mapping table and call this Field_Mapping table using un-connected lookup to determine currently processed file's structure.
Views: 42424 Mandar Gogate
Informatica : Remove Duplicate Records
Scenario Based Interview Question -- How can you remove duplicate records while inserting into target table?
Views: 24039 Mandar Gogate
Informatica : Executing Session Conditionally Based On Workflow Variable.avi
Scenario Based Interview Question -- There is a workflow having 3 sessions in sequence. A--B--C. We want session C to run only on 12 successful completions of session B. How would you do that?
Views: 29786 Mandar Gogate
Informatica : UserDefined Functions
How to create Private and Public User Defined Functions in Informatica
Views: 1576 Mandar Gogate
Informatica : Deleting And Retrieving Objects.avi
Deleting N number of informatica objects and Retriving those again using informatica repository manager.
Views: 5232 Mandar Gogate
Pre Post Attribute Execution At Source and Target of Informatica
Intention of this video to find out in which order queries written in Pre and Post SQL attributes of Informatica Source and Target will be executed
Views: 1883 Mandar Gogate
Informatica : Update Records Without Update Strategy
How to update records without using update strategy tranformation. Its a typical interview question, and we will be doing that by changing the source and target properties at session level
Views: 27933 Mandar Gogate
Informatica : SQL Tranformation
Updating records at relational target using Dynamic Update query at SQL Tranformation in informatica
Views: 39749 Mandar Gogate
Informatica : Associating Session To Different Mapping
How to point a particular session to a different mapping?
Views: 755 Mandar Gogate
Informatica : Dividing Records In Two Half
Scenario Based Interview Question -- How can you divide source records in such a way that, first half of records will get loaded in one target and another half of records in second target?
Views: 16226 Mandar Gogate
Informatica : Clob Data Type To Blob Data Type Conversion using Java Tranformation
Converting Character Large Object of Source to Binary Large Object of Target using Informatica Java Transformation. For more information please check http://gogates.blogspot.in/2013/09/transfering-clob-data-to-blob-using.html
Views: 5472 Mandar Gogate
Informatica : Deployment Group.avi
Deploying objects using static deployment group in informatica.
Views: 24061 Mandar Gogate
Informatica Static Lookup OverRide
How informatica will generate Lookup over-ride by default and what things we have to do in-order to add our own lookup over-ride
Views: 6694 Mandar Gogate
Informatica : Oracle To Teradata Using ParameterFile
Inserting data from Oracle table to Teradata table wherein at Source Qualifier we pass the SQL Query value using Mapping Parameter and Source and Target connection values from Session Parameter..
Views: 7906 Mandar Gogate
Informatica Installation On Linux - Part5 (Connecting Client to Server)
Connecting Informatica Windows Client to Informatica 9.5.1 Server installed on Linux Machine
Views: 4298 Mandar Gogate
Informatca : Parameter File Creation using Infra Mapping (Part 1)
How to create a Parameter File Dynamically using Informatica Mapping and Metadata Entries.
Views: 4522 Mandar Gogate
Informatica : Mapping Variable Assignment And OutPut Port
When you are doing Variable Assignment using output port in a mapping, you have to connect the output port to next available port; since then only your assignment expression gets executed. If you don't do that, your variable assignment fails.
Views: 5579 Mandar Gogate
Informatica : Import Excel Data At Informatica
Inserting data defined in 2 separate tabs at Excel into Relational Target using informatica. Use ODBC connection at informatica to import Excel as a source
Views: 23619 Mandar Gogate
Creating BO Report Using BO Rich Client
Report Creation Using Business Objects 4.0 Rich Client
Views: 2938 Mandar Gogate
Informatica : Backup And Restoring Domain
How to move informatica Domain from one schema [or database] to different schema [database]? How to take backup / restore of Informatica Domain?
Views: 5059 Mandar Gogate
Informatica : Partitioning Lookup Transformation using Partial Pipeline
How to configure session for Partitioned Lookup Transformation with Partial Pipeline?
Views: 4668 Mandar Gogate
Informatica : Single Thread And Multi Thread Pass Through Partitioning For Flat File Source
How and When to configure a session for Single or Multiple Thread Pass Through Partitioning having Flat File as a Source? Use of Aggregator transformation in this video with Pass Through partitioning is just to show the Single & Multiple Thread Partitioning implementation.
Views: 5409 Mandar Gogate
Informatica : Session Logs
1. What is a informatica session log directory absolute path? how will you find and change that? 2. How will you archive session logs? and why is a need for that? 3. How will you create a session log which is readable?
Views: 6944 Mandar Gogate
Informatica : Sql And Stored Procedure Transformations [Part-1]
How to use SQL and Stored Procedure transformation for dumping data from Oracle to Teradata database
Views: 7298 Mandar Gogate
FTP Commands To Transfer Files
Transferring the files using ftp command..with option -i, -n and get, mget, put, mput.
Views: 119197 Mandar Gogate
Creating Universe In Business Objects - 4
Universe Creation Using Business Objects - 4
Views: 27297 Mandar Gogate
Informatica : Static Lookup Basic insert update
Implementation of Static Lookup at Insert Update records.
Views: 7012 Mandar Gogate
Informatica : Adding Header Footer to Flat File Target
How to add Header & Footer to a Flat File Target of Informatica
Views: 14951 Mandar Gogate
Informatica Installation On Linux - Part3 (Informatica Server Installation)
Informatica 9.5.1 Server Installation on Oracle Linux
Views: 16857 Mandar Gogate