in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna
5 13279i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica
5 11967I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.
4 13350Design 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
1506Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
2434Post New Cap Gemini Informatica Interview Questions
How a base class method is hidden?
How much training do you think you'll need to become a productive employee?
When to use ngoninit and constructor in angular 2?
What are the different abap editors? What is the used of different editors in abap?
How to download and install microsoft .net framework version 2.0?
Define the functions of the dx register.
What does putty stand for?
Difference between save() and saveorupdate() method of hibernate?
What is the average salary that zoologist that work in the feild of ethology make.
In database testing, what do we need to check normally?
What is the default namespace of lightning component? : salesforce lightning component
What does ampere turns shows?
How do I delete a dll file?
how cam www sites be tested
How can one billing document type has 2 different number system? Basically if there are two documents belonging to same document type but for two different plants, then how come they both have different number system?