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 13249i 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 11952I 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 13330Design 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
1498Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
2425Post New Cap Gemini Informatica Interview Questions
What is google fetch?
What technology is used to generate pcui screens?
You are the project manager for Changing Tides video games. You have gathered the inputs for the Activity Duration Estimating process. You will employ which tools and techniques to produce the outputs for this process? A. Activity list, analogous estimating, quantitatively based durations, and alternatives identification B. Activity list, analogous estimating, expert judgment, and quantitatively based durations C. Expert judgment, analogous estimating, quantitatively based durations, and reserve time D. Expert judgment, alternatives identification, quantitatively based durations, and reserve time
Three people are responsible for establishing cost of quality theories. Crosby and Juran are two of them, and their theories respectively are: A. Grades of quality, fitness for use B. Fitness for use, zero defects C. Zero defects, fitness for use D. Cost of quality, zero defects
What request type from a rest resource allows one update the contents of a file?
How wireless communications may affect the development and implementation of the internet of factors (iot)?
What is data string?
Do I have to credit struts on my own website?
What is ctrl f5?
What are gaps? Some examples?
How and when does the db2 enforces the unique key?
Explain the difference between data science, machine learning and artificial intelligence?
During scrum meeting what all things are done?
Difference json arrary vs json object ?
Why is it called cascading style sheets?