Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500
977Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
1822There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?
1 1649I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
1063pmscmd startworkflow -sv
HCL,
1035Post New Informatica Questions
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
How to partition the Session?
What is pmcmd command?
What is the meaning of up gradation of repository?
What are the transformations that are not supported in mapplet?
Explain the difference between a data warehouse and a data mart?
What are the performance considerations when working with aggregator transformation?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How do you load only null records into target? Explain through mapping flow.
Briefly define a session task?
pmscmd startworkflow -sv
Which version configuration tool used in ur project?
Mention some types of transformation?
can u any challenge your project?
How to load the data from a flat file into the target where the source flat file name changes daily?
