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 12594i 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 11354I 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 12744Design 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
1337Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
2218Post New Cap Gemini Informatica Interview Questions
What is the effect of keeping a constructor private?
How to create field as mandatory?
Does Kotlin have the static keyword? How to create static methods in Kotlin?
What are the Initiation process outputs? A. Project charter, historical information, and project manager identification and assignment B. Project charter, project manager identification and assignment, constraints, and assumptions C. Project charter, historical information, constraints, and assumptions D. Project charter, constraints, and assumptions
Explain what minerals attract lightning?
I want to count the number of cells in a range that have a particular interior color. The countif function seems like the right kind of answer but how to I return thecolor of the interior for each cell in a range? I would like to do something like: =countif(b1:b10, cell("interior","red"))?
Why wordpress is so popular?
Which module can be used for e-commerce?
Difference between open_form and call_form in oracle.
Difference between Timeout and Wait conditions?
what is Mineralcrisis?
how do i remedy a foundatiom that the column bases was cast and aftet 28days crushing the conprehensive strength of the concrete fall below the specification 25N/mm2
xpression 'document.FrmQF.myemail' [
how SQL statement is processed in SAP HANA?
What is tomcat web xml?