How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
3 4701How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
1 11356if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not
2 3920a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100
2 5322The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?
3 4590i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?
5 5077I want expect first and last record remaining all records will be loaded into target? which transformations we can use?
6 9452source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
1356My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?
3 6053Post New Cap Gemini Informatica Interview Questions
Describe the test procedure to determine the vector group
What is expention fastener (Fan)
What is the reason behind current flow(20 A) in amain earth cable of an SMDB? Is cuurent flow(45A etc) through a neutral cable acceptable?
what are the Prerequisites for Replication?
meron po bang minerals ang astoroids po ba?
What is Partial Discharge test .Please specify that this test can be test on 11/0.433 KV,630 KVA Transformer.
how can calculate cutting length of diamond ring
How does Ultraviolet Light Affects Seed Germination and plant growth?
what is an unbalance in acircuit? in a three phase 3wire circuit how an unbalance will come? in a three phase four wire system how an un balance is coming?
Expand-------URM
who or what in your life would you say influenced you most with regard to your career objectives?
What is HSN? How do we apply it?
If secondary server finds out that the Primary is down and comes up.Where does it gets the messages from.
how to calculate earth fault relay current and CBCT ratio
What are the GL postings in porocure to pay cycle?
- 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 (83)
- 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 (108)
- SAPScript (3)
- SAP SD (96)
- SAP MM (20)
- SAP PP (2)
- SAP FI CO (64)
- SAP HR (27)
- SAP CRM (55)
- SAP APO (1)
- SAP Business Warehouse (9)
- SAP Security (19)
- 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 (14)
- 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)
