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
Lookup as Active transformation with feature as "Pass All Matching Rows"
Views: 11183 Mandar Gogate
Informatica Static Lookup Tranformation With Enabling Persistent Cache Option
Views: 16311 Mandar Gogate
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
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 External Loader utility as Oracle Target.. Please view this video in full screen mode
Views: 7228 Mandar Gogate
How Informatica Integration Service shares static lookup cache in same / different mappings in same / different target load order group?
Views: 4640 Mandar Gogate
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
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
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
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
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
How to point a particular session to a different mapping?
Views: 755 Mandar Gogate
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
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
Connecting Informatica Windows Client to Informatica 9.5.1 Server installed on Linux Machine
Views: 4298 Mandar Gogate
How to create a Parameter File Dynamically using Informatica Mapping and Metadata Entries.
Views: 4522 Mandar Gogate
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
How to configure session for Partitioned Lookup Transformation with Partial Pipeline?
Views: 4668 Mandar Gogate
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
How to use SQL and Stored Procedure transformation for dumping data from Oracle to Teradata database
Views: 7298 Mandar Gogate
How to add Header & Footer to a Flat File Target of Informatica
Views: 14951 Mandar Gogate
Informatica 9.5.1 Server Installation on Oracle Linux
Views: 16857 Mandar Gogate