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
998Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
1843There 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 1682I 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)
1091pmscmd startworkflow -sv
HCL,
1055Post New Informatica Questions
What are the tasks that can be performed using sq?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What are mapplets? How is it different from a Reusable Transformation?
What can we do to improve the performance of informatica aggregator transformation?
What are the informatica performance improvement tips
server hot-ws270 is connect to Repository B. What does it mean?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
How to load last n records of file into target table - informatica
Write the program through which the records can be updated?
how many types of dimensions are available in informatica?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is the difference between informatics 7x and 8x and what is latest version?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What do you mean by enterprise data warehousing?
