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 7360i 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 7304I 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 8547Design 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
189Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
194Post New Cap Gemini Informatica Interview Questions
Is this house typical of the houses of this community? What makes it typical or atypical?
principle of dissolution
What can you contribute to the company?
what is the diffrence between trade customer and non trade customer .
draw the circuit diagram of a transistor frequency convertor using a tetrode transistor?
How to enable Fault Tolerance features in the ORB?
what are the key tasks for production planner?
what is x'mer ,isolation x'mer & yltra-isolation x'mer?????
How would you include common or reuse to be processed along with your statements?
tell me the scenarios of the independent in reports
In a four-stroke diesel engine, In what engine exhaust valve will open?
Slab quantity
what is meant by source control?
What are step loops? How do you program page down page up in step loops?
What is the best way to develop pay systems that are understandable, Workable, and acceptable to employees at all levels?
- 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 (1)
- 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 (19)
- SAS (3)
- ETL (4)
- Data Warehouse General (2)
- HR Questions (5)
- WiFi Security (1)
- SAP Basis (27)
- SAP ABAP (109)
- SAPScript (3)
- SAP SD (96)
- SAP MM (20)
- SAP PP (2)
- SAP FI CO (66)
- SAP HR (27)
- SAP CRM (55)
- SAP APO (1)
- SAP Business Warehouse (9)
- SAP Security (23)
- 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)
- 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)
