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
4 7432i 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 7384I 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 8667Design 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
212Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
226Post New Cap Gemini Informatica Interview Questions
Explain how can I vertically scale an Amazon instance?
1.what promted you to become involved in QA/Testing?
How are fisheries regulated?
Does Kylix support Postgres?
If you have two 132KV distance scheme and you are using fibre for comms but the two relays on are not compatible interms of comms what can you use to allow communication between the two relays.
What is the use of Extension Manager?
Explain the Thawing of competent bacterial cells ?
CAN WE HAVE THE ARRANGEMENT OF QUARKS OF PROTON 'UP,DOWN,UP' INSTEAD OF 'UP,UP,DOWN'?
Why to use propyl paraben in HPLC gradient calibration
Insights of a 4bit adder/Sub Circuit?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
what is servo motor and how it works?
In Table Field when display the Name, whose first charecter should be capital letter and rest will be small letter.
sir ,i applied rrb chennai for the post of junier engineer please sent model question papper with solved data to my mail id.aravindaptc@yahoo.co.in
I want technical questions of previous reqruitment examination
- Software (1)
- C (2)
- OOPS (2)
- C++ General (1)
- COM DCOM (2)
- VC++ AllOther (1)
- Programming Languages AllOther (2)
- CGI Perl (1)
- VB Script (10)
- Shell Script (4)
- UDP (1)
- Networking AllOther (1)
- Visual Basic (1)
- C Sharp (1)
- ASP.NET (6)
- Crystal Reports (1)
- BizTalk (1)
- Dot Net Framework (3)
- Dot Net AllOther (1)
- Exchange Server (1)
- Oracle General (9)
- Database Management (2)
- Forms Reports (1)
- Oracle AllOther (4)
- SQL Server (18)
- MySQL (1)
- DB Administration (2)
- SQL PLSQL (15)
- Databases AllOther (1)
- Linux AllOther (1)
- Unix Commands (3)
- Unix General (4)
- Unix AllOther (2)
- Solaris AllOther (3)
- Operating Systems General Concepts (1)
- WinRunner (1)
- Load Runner (3)
- QTP (40)
- Test Director (1)
- Selenium (1)
- Automation Testing AllOther (1)
- Manual Testing (84)
- QA Concepts (15)
- Mobile Testing (1)
- Test Cases (7)
- Test Documents Reporting (1)
- Testing AllOther (19)
- COBOL (21)
- JCL (16)
- CICS (14)
- DB2 (31)
- IMS (2)
- Natural (1)
- MVS (1)
- VSAM (5)
- RPG400 (8)
- COBOL400 (1)
- DB400 (3)
- Core Java (17)
- Advanced Java (5)
- Swing (1)
- Struts (2)
- JDBC (1)
- Weblogic (2)
- Java J2EE AllOther (4)
- Java Related AllOther (4)
- MQSeries (2)
- Middleware AllOther (1)
- SOAP (1)
- Teradata (9)
- Business Objects (18)
- Cognos (24) Informatica (67)
- Ab Initio (2)
- Data Stage (20)
- SAS (3)
- ETL (4)
- Data Warehouse General (2)
- HR Questions (5)
- WiFi Security (1)
- SAP Basis (27)
- SAP ABAP (110)
- SAPScript (3)
- SAP SD (96)
- SAP MM (21)
- SAP PP (2)
- SAP FI CO (66)
- SAP HR (27)
- SAP CRM (55)
- SAP APO (1)
- SAP Business Warehouse (9)
- SAP Security (24)
- SAP Netweaver (1)
- SAP ALE IDocs (2)
- SAP B1 (1)
- SAP Business Objects BO BOBJ (1)
- CRM General (1)
- Siebel (14)
- Oracle Apps Technical (11)
- Oracle Apps Financial (19)
- Oracle Apps Manufacturing (1)
- Oracle Apps HRMS (1)
- Oracle Apps SCM (6)
- WebMethods (10)
- TIBCO (1)
- Mechanical Engineering (2)
- Electrical Engineering (4)
- Electronics Communications (2)
- Engineering AllOther (3)
- Marketing Sales (2)
- Banking Finance (3)
- Audit (2)
- Taxation (3)
- Accounting General (15)
- Accounting AllOther (15)
- Call Centre AllOther (3)
- BSRB AllOther (1)
- Law AllOther (1)
- Everything Else AllOther (1)
- English (2)
- General Aptitude (24)
- Placement Papers (1)
- CCNA (1)
- Sun Certifications (1)
- Certifications AllOther (1)
- H1B Visa (2)
- USA Student Visa F1 Visa (1)
- L1 Visa (2)
- USA Business Visa B1 Visa (1)
- USA Dependent Visa H4 Visa (2)
- C Code (1)
- Programming Code AllOther (1)
- Oracle Errors (1)
- MySQL Errors (1)
