In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation.
If millions of files are there, how can we enter the flat file names in list file?
What is the use of incremental aggregation?
One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?
My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
what is pre and post sql and what is diff between source presql and target pre sql
3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?
how can one come to know wether the records loak into the target if we use update strategy
hi all, can anyone please tell me the difference between erwin tool and informatica ?how these both works ? how this both are going to connect with business objects. THANKS IN ADVANCE
Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.
What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1
How can we use mapping variables in informatica? Where do we use them?
Reusable transformation and shortcut differences