Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
No Answer is Posted For this Question
Be the First to Post Answer
what is shortcut in informatica? difference between shortcut,reusable object?
What is source qualifier?
What is the difference Between Mapping parameter and variable
Scenario:- Below is the requirement. Source:- NAME ID Requirement RAVI 1 (no need to repeat as it ID is 1) KUMAR 3 (repeat 3 times as it ID is 3) John 4 (repeat 4 times as it ID is 4) Required Out Put:- Name ID RAVI 1 KUMAR 3 KUMAR 3 KUMAR 3 John 4 John 4 John 4 John 4 Scenario 2:- Source Data ID NAME 1,2 NETEZZA,ORACLE 3,4,5 SQL Server, DB2, Teradata Required Output:- ID NAME 1 NETEZZA 1 ORACLE 3 SQL Server 3 DB2 3 Teradata
What is DR strategy for Informatica project?
In informatics server which files are created during the session rums?
What is use of batch file in informatica? How many types of batch file in informatica?
scenario
how i will stop my workflow after 10 errors
what is threshold error in informatica?
If the records doesnt satisfy the filter condition where will it go?
in which situations do u go for sequence generator ?