Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

  • Accenture aptitute test questions (64)
  • Accenture interview questions (1804)
  • Accenture placement papers (24)
  • Accenture technical test questions (103)



Accenture Informatica Interview Questions
Questions Answers Views Company eMail

Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti

1 2745

Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?

6 10403

Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.

5 6050

How to convert flat file into xml file? How to tune joiner?

2 7816

3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?

7 7003





what is shared lookup&persistent lookup?

4 6791

what are the unix commands to start the wrk flow ?

4 7670

What is the difference Between Mapping parameter and variable

3 6492

What is update override?

1 4005

How can u insert o ne row in the target if that row does not exists in the target and update if it exists

6 9496

what are the limitations for bulk loading in informatica for all kind of databases and transformations?

3 10271

1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?

2 14680

how to join the 2 different table with different columns in informatica?

5 17016

How to load the source table into flat file target(with columns) in informatica?

4 12948

when will we use unconnected & connected lookup? How it will effect on the performance of mapping?

5 9676

Post New Accenture Informatica Interview Questions



Un-Answered Questions

I have two PLC processors. I want to communicate both processor with each other. How i can do so?

855


Did QTP prove efficient for your project? Yes or No, explain?

4652


in single phase converter, the no.of scr's conducting during overlap a)1 b)2 c)3 d)4

855


10.Define filters,binary to hexadecimal,hexadecimal to decimal?

846


Objective The objective of this problem is to test the understanding of Object-Oriented Programming (OOP) concepts, in particular, on encapsulation. Problem Description Create a program for managing customer’s bank accounts. A bank customer can do the following operations: 1. Create a new bank account with an initial balance. 2. Deposit money into his/her account. 3. Withdraw money from his/her account. For this operation, you need to output “Transaction successful” if the intended amount of money can be withdrawn, otherwise output “Transaction unsuccessful” and no money will be withdrawn from his/her account. Input The input contains several operations and is terminated by “0”. The operations will be “Create name amount”, “Deposit name amount”, or “Withdraw name amount”, where name is the customer’s name and amount is an integer indicating the amount of money. There will be at most 100 bank accounts and they are all created on the first month when the bank is opening. You may assume that all account holders have unique names and the names consist of only a single word. Output The output contains the transaction result of withdrawal operations and the final balance of all customers after some withdrawal and deposit operations (same order as the input). Sample Input Create Billy 2500 Create Charlie 1000 Create John 100 Withdraw Charlie 500 Deposit John 899 Withdraw Charlie 1000 0

967






Can you give names of Container classes?

1162


mccb service sittings be done?

611


what is consequences of neutral and earth connect?

699


If more than rated DC voltage appears across trip coil of the breaker, what will happen? e.g. in 110V DC circuit system, if voltage across battery terminal showing 121 V

421


Question 1 A low-level format received by a floppy disk does what? a. Adds a root directory b. Includes a FAT (File Allocation Table) c. Stores 720K d. Creates a structure of sectors, tracks, & cluster. Question 2 A user is complaining of problems. You find that upon startup, the IBM machine give two beeps alerting you to a POST error. Error code 301 shows. What is wrong with this machine? a. There is a monitor error. b. There is a keyboard error. c. This is not a POST error. Two beeps indicates a motherboard error. d. There is a serial card error. Question 3 What is this an example of? A. A 30-pin SIMM B. A 72-pin SIMM C. A 168-pin DIMM D. C-RIMM Question 4 Bridges are capable of which? a. Expanding the length of a network segment. b. Acting as a firewall. c. Segmenting networks. d. Communication of computers on a LAN. Question 5 Which is true of a female DB 15-pin video port? a. It has 2 rows of 5 pinholes. b. It has 3 rows of 5 pinholes. c. It has one row of 8 pinholes and one row of 7 pinholes d. It has one row of 6 pinholes and one row of 9 pinholes Question 6 You have just installed two hard drives into the same machine. One is set up as the slave and both are on the same IDE channel. You notice that the drive's LED light is constantly lit on the slave drive. What do you need to do to fix this? a. Troubleshoot the slave drive by reconfiguring the slave to be the master, removing the original master drive, then rebooting. b. Disable the secondary controller in the BIOS. c. Manually enter the drive settings on the BIOS. d. Install more memory. Question 7 SVGA and Ultra VGA are two distinct video standards. True or False? a. True. b. False. Question 8 SVGA is represented by all of the following resolutions except: a. 1600 x 1200 b. 800 x 600 c. 640 x 480 d. 1280 x 1024 Question 9 Which is true of an Active Matrix LCD? a. The LCD is divided into two halves. b. The LCD is divided into two halves. c. Each pixel is constantly refreshed. d. The pixels are fixed. e. It uses more electricity. f. None of the above. Question 10 What are the correct stages and order of the EP laser printing process? a. Cleaning, Writing, Conditioning, Developing, Fusing, Transferring, and End of Cycle b. Cleaning, Conditioning, Writing, Developing, Transferring, Fusing, & End of Cycle c. Erasing, Writing, Heating, Developing, Fusing, Transferring, & End of Cycle d. Conditioning, Erasing, Writing, Developing, Fusing, Transferring, & End of Cycle Question 11 Choose the correct associations (pick 2). a. 802.4 – Internetworking b. 802.6 - Metropolitan area network c. 802.9 - Integrated voice and data networks d. 802. 11 - Token ring LAN Question 12 What is the function of a Layer 2 switch ? a. forwards data based on logical addressing b. duplicates the electrical signal of each frame to every port c. learns the port assigned to a host by examining the destination MAC address d. determines which interface is used to forward a frame based on the destination MAC address. Question 13 An administrator would like to connect ten workstations on a 192.168.0.0/24 network. The device selected by the administrator must allow connectivity between hosts without sharing bandwidth. Which device would be appropriate? a. Hub b. Router c. Switch d. Repeater Question 14 Which devices are primarily used to extend cable segments within a collision domain by regenerating the data signals? (Choose two.) a. switch b. repeater c. router d. bridge e. hub Question 15 Which networking devices use the MAC address to make forwarding decisions? (Choose two.) a. NIC b. bridge c. hub d. switch e. repeater Software : 1. Briefly describe the data type conversion feature of Oracle SQL and PL/SQL. 2. What is INDEX? Describe its benefits. 3. Write down the name of five most popular RDBMS. 4. What is UML? Write some Diagram name. 5. What is HTML and XML? 6. What is CSS and AJAX and their benefits? 7. What is software quality assurance? 8. Describe components of a typical test plan? 9. What is the difference between QC and QA? 10. What is Verification and Validation? 11. What diff b/w black box and white box testing? 12. What is the difference between System Testing, Integration Testing & System Integration Testing? ATI Limited Question Paper Duration Time : 1 Hour and 30 Minutes Question 1 A low-level format received by a floppy disk does what? a. Adds a root directory b. Includes a FAT (File Allocation Table) c. Stores 720K d. Creates a structure of sectors, tracks, & cluster. Question 2 A user is complaining of problems. You find that upon startup, the IBM machine give two beeps alerting you to a POST error. Error code 301 shows. What is wrong with this machine? a. There is a monitor error. b. There is a keyboard error. c. This is not a POST error. Two beeps indicates a motherboard error. d. There is a serial card error. Question 3 What is this an example of? A. A 30-pin SIMM B. A 72-pin SIMM C. A 168-pin DIMM D. C-RIMM Question 4 Bridges are capable of which? a. Expanding the length of a network segment. b. Acting as a firewall. c. Segmenting networks. d. Communication of computers on a LAN. Question 5 Which is true of a female DB 15-pin video port? a. It has 2 rows of 5 pinholes. b. It has 3 rows of 5 pinholes. c. It has one row of 8 pinholes and one row of 7 pinholes d. It has one row of 6 pinholes and one row of 9 pinholes Question 6 You have just installed two hard drives into the same machine. One is set up as the slave and both are on the same IDE channel. You notice that the drive's LED light is constantly lit on the slave drive. What do you need to do to fix this? a. Troubleshoot the slave drive by reconfiguring the slave to be the master, removing the original master drive, then rebooting. b. Disable the secondary controller in the BIOS. c. Manually enter the drive settings on the BIOS. d. Install more memory. Question 7 SVGA and Ultra VGA are two distinct video standards. True or False? a. True. b. False. Question 8 SVGA is represented by all of the following resolutions except: a. 1600 x 1200 b. 800 x 600 c. 640 x 480 d. 1280 x 1024 Question 9 Which is true of an Active Matrix LCD? a. The LCD is divided into two halves. b. The LCD is divided into two halves. c. Each pixel is constantly refreshed. d. The pixels are fixed. e. It uses more electricity. f. None of the above. Question 10 What are the correct stages and order of the EP laser printing process? a. Cleaning, Writing, Conditioning, Developing, Fusing, Transferring, and End of Cycle b. Cleaning, Conditioning, Writing, Developing, Transferring, Fusing, & End of Cycle c. Erasing, Writing, Heating, Developing, Fusing, Transferring, & End of Cycle d. Conditioning, Erasing, Writing, Developing, Fusing, Transferring, & End of Cycle Question 11 Choose the correct associations (pick 2). a. 802.4 – Internetworking b. 802.6 - Metropolitan area network c. 802.9 - Integrated voice and data networks d. 802. 11 - Token ring LAN Question 12 What is the function of a Layer 2 switch ? a. forwards data based on logical addressing b. duplicates the electrical signal of each frame to every port c. learns the port assigned to a host by examining the destination MAC address d. determines which interface is used to forward a frame based on the destination MAC address. Question 13 An administrator would like to connect ten workstations on a 192.168.0.0/24 network. The device selected by the administrator must allow connectivity between hosts without sharing bandwidth. Which device would be appropriate? a. Hub b. Router c. Switch d. Repeater Question 14 Which devices are primarily used to extend cable segments within a collision domain by regenerating the data signals? (Choose two.) a. switch b. repeater c. router d. bridge e. hub Question 15 Which networking devices use the MAC address to make forwarding decisions? (Choose two.) a. NIC b. bridge c. hub d. switch e. repeater Software : 1. Briefly describe the data type conversion feature of Oracle SQL and PL/SQL. 2. What is INDEX? Describe its benefits. 3. Write down the name of five most popular RDBMS. 4. What is UML? Write some Diagram name. 5. What is HTML and XML? 6. What is CSS and AJAX and their benefits? 7. What is software quality assurance? 8. Describe components of a typical test plan? 9. What is the difference between QC and QA? 10. What is Verification and Validation? 11. What diff b/w black box and white box testing? 12. What is the difference between System Testing, Integration Testing & System Integration Testing?

5059


Hi could some one please send me the testplan testcases(for 2Modules) and testscripts for mercry fliht aplication or gmail. please write those on templates and send me.In testplan plase write Testobjective, test scope, est approach, exlusions assumptios.

722


how did i get the competency certificate as electricle supervisor. iam completed my b.tech.but i dnt have any experince, this certificate is required for applyng ongc mangement trainees. what should i do sir please suggested me

730


how to pass TDS intery in tally?

1528


hello frnds this pooja i hav started working on selenium with java ecllipse frnds could u tell me how to handle popup windows and security alerts i m jst trying and couldn't do anything plz help

894


how to making game in c++ ?

1267






Accenture Informatica Interview Questions
  • C (58)
  • OOPS (10)
  • C++ General (4)
  • COM DCOM (1)
  • Delphi (1)
  • PHP (1)
  • Programming Languages AllOther (13)
  • JavaScript (1)
  • VB Script (7)
  • JSP (1)
  • Awk (1)
  • Scripts AllOther (1)
  • SNMP (2)
  • TCP IP (1)
  • Protocols AllOther (6)
  • Networking Administration (5)
  • Networking Security (1)
  • Networking AllOther (1)
  • Visual Basic (1)
  • C Sharp (10)
  • ASP.NET (74)
  • ADO.NET (5)
  • Crystal Reports (1)
  • BizTalk (5)
  • Dot Net Framework (13)
  • Dot Net WindowsForms (1)
  • Dot Net General (2)
  • Dot Net AllOther (2)
  • Exchange Server (5)
  • Microsoft Related AllOther (2)
  • Oracle General (6)
  • Forms Reports (1)
  • Oracle AllOther (3)
  • SQL Server (21)
  • MySQL (1)
  • DB Administration (2)
  • SQL PLSQL (15)
  • Databases AllOther (2)
  • SDK (1)
  • Windows Threads (1)
  • Windows General (4)
  • Windows AllOther (4)
  • Linux System Calls (2)
  • Linux AllOther (3)
  • Unix Commands (2)
  • Unix General (8)
  • Unix AllOther (2)
  • Solaris Commands (4)
  • Solaris System Calls (1)
  • Solaris AllOther (2)
  • Operating Systems General Concepts (3)
  • Data Structures (1)
  • WinRunner (24)
  • Load Runner (12)
  • QTP (64)
  • Test Director (1)
  • Rational TestSuite (3)
  • Selenium (1)
  • Automation Testing AllOther (5)
  • Manual Testing (120)
  • QA Concepts (7)
  • Test Cases (9)
  • Test Documents Reporting (1)
  • Testing AllOther (17)
  • COBOL (13)
  • JCL (12)
  • CICS (10)
  • DB2 (13)
  • IMS (2)
  • IBM MainFrame AllOther (14)
  • RPG400 (1)
  • COBOL400 (1)
  • DB400 (2)
  • IBM AS400 AllOther (3)
  • Core Java (36)
  • Advanced Java (2)
  • Swing (1)
  • EJB (1)
  • Servlets (6)
  • Struts (5)
  • JDBC (1)
  • J2EE (1)
  • Weblogic (2)
  • Java Networking (2)
  • Java J2EE AllOther (1)
  • Middleware AllOther (2)
  • HTML DHTML (1)
  • XML XSLT RSS (1)
  • Teradata (4)
  • Business Objects (29)
  • Cognos (8)
  • Informatica (60)
  • Ab Initio (4)
  • Data Stage (12)
  • SAS (97)
  • ETL (6)
  • Data Warehouse General (6)
  • HR Questions (34)
  • Design Patterns (3)
  • Project Planning (1)
  • VSS (1)
  • SAP Basis (25)
  • SAP ABAP (155)
  • SAPScript (4)
  • SAP SD (104)
  • SAP MM (32)
  • SAP QM (1)
  • SAP PP (7)
  • SAP PM (1)
  • SAP PS (1)
  • SAP FI CO (111)
  • SAP HR (20)
  • SAP CRM (17)
  • SAP APO (2)
  • SAP Business Warehouse (20)
  • SAP Security (28)
  • SAP Interfaces (1)
  • SAP Netweaver (4)
  • SAP ALE IDocs (2)
  • SAP B1 (3)
  • SAP AllOther (3)
  • PeopleSoft Administration (1)
  • PeopleSoft Tools (2)
  • Siebel (4)
  • Oracle Apps Technical (37)
  • Oracle Apps Financial (21)
  • Oracle Apps Manufacturing (2)
  • Oracle Apps HRMS (1)
  • Oracle Apps SCM (5)
  • Oracle Install Base (1)
  • Oracle Service Contracts (2)
  • ERP CRM AllOther (1)
  • Client Server Architecture (3)
  • AI Tools (3)
  • WebMethods (7)
  • TIBCO (11)
  • EAI AllOther (12)
  • Change Request Management (1)
  • Bio Informatics (1)
  • Sciences AllOther (1)
  • Electrical Engineering (12)
  • Electronics Communications (5)
  • Engineering AllOther (4)
  • Business Administration (1)
  • Marketing Sales (3)
  • Banking Finance (7)
  • Human Resources (4)
  • IT Management (2)
  • Non Technical (1)
  • Business Management AllOther (1)
  • Audit (4)
  • CompanyAffairs CS (1)
  • Taxation (8)
  • Accounting General (90)
  • Accounting AllOther (59)
  • Call Centre AllOther (32)
  • APPSC AllOther (1)
  • General Knowledge_Current Affairs (4)
  • Government AllOther (2)
  • Everything Else AllOther (6)
  • English (3)
  • General Aptitude (47)
  • Puzzles (6)
  • Placement Papers (25)
  • CCNA (2)
  • Microsoft Certifications (2)
  • Oracle Certifications (1)
  • Certifications AllOther (2)
  • L1 Visa (2)
  • USA AllOther Visa (4)
  • Australia Visa (1)
  • C Code (4)
  • GATE (1)
  • GMAT (3)
  • Scripts Errors (1)