Home  
 
  Ask Questions  
 
  Feed Back  
 
  My Questions  
 
  Contact Us  
 
  About Us  
 


 Interview Questions  
 Our Services  

Informatica Interview Questions and Answers

NEW INTERVIEW QUESTIONS.COM DATA WAREHOUSING INTERVIEW QUESTIONS INFORMATICA INTERVIEW QUESTIONS QUESTIONS LISTING

Informatica Interview Questions & Answers


A D V E R T I S E M E N T





Previous Page 1 Page 2 Page 3 Page 4 Page 5 [ Page 6] Page 7 Page 8 Page 9 Page 10 Page 11 Page 12 Page 13 Page 14 Page 15 Page 16 Page 17 Page 18 Page 19 Next

Newinterviewquestions.com: World's Largest Interview Questions Website.
Questions Question: How to create the staging area in your database
Ratings Rating:
View Answer View Answer: Here

Questions Question: What does the expression n filter transformations do in Informatica Slowly growing target wizard?
Ratings Rating:
View Answer View Answer: Here

Questions Question: In a filter expression we want to compare one date field with a db2 system field CURRENT DATE. Our Syntax: datefield = CURRENT DATE (we didn't define it by ports, its a system field ), but this is not valid (PMParser: Missing Operator).. Can someone help us. Thanks
Ratings Rating:
View Answer View Answer: Here

Questions Question: Briefly explian the Versioning Concept in Power Center 7.1.
Ratings Rating:
View Answer View Answer: Here

Questions Question: How to join two tables without using the Joiner Transformation.
Ratings Rating:
View Answer View Answer: Here

Questions Question: Identifying bottlenecks in various components of Informatica and resolving them.
Ratings Rating:
View Answer View Answer: Here

Questions Question: Identifying bottlenecks in various components of Informatica and resolving them.
Ratings Rating:
View Answer View Answer: Here

Questions Question: Can Informatica be used as a Cleansing Tool? If Yes, give example of transformations that can implement a data cleansing routine.
Ratings Rating:
View Answer View Answer: Here

Questions Question: How do you decide whether you need ti do aggregations at database level or at Informatica level?
Ratings Rating:
View Answer View Answer: Here

Questions Question: How do we estimate the depth of the session scheduling queue? Where do we set the number of maximum concurrent sessions that Informatica can run at a given time?
Ratings Rating:
View Answer View Answer: Here

Questions Question: How do we estimate the number of partitons that a mapping really requires? Is it dependent on the machine configuration?
Ratings Rating:
View Answer View Answer: Here

Questions Question: Suppose session is configured with commit interval of 10,000 rows and source has 50,000 rows. Explain the commit points for Source based commit and Target based commit. Assume appropriate value wherever required.
Ratings Rating:
View Answer View Answer: Here

Questions Question: We are using Update Strategy Transformation in mapping how can we know whether insert or update or reject or delete option has been selected during running of sessions in Informatica.
Ratings Rating:
View Answer View Answer: Here

Questions Question: What is the procedure to write the query to list the highest salary of three employees?
Ratings Rating:
View Answer View Answer: Here

Questions Question: Which objects are required by the debugger to create a valid debug session?
Ratings Rating:
View Answer View Answer: Here

Questions Question: What is the limit to the number of sources and targets you can have in a mapping
Ratings Rating:
View Answer View Answer: Here

Questions Question: Which is better among connected lookup and unconnected lookup transformations in informatica or any other ETL tool?
Ratings Rating:
View Answer View Answer: Here

Questions Question: In Dimensional modeling fact table is normalized or denormalized?in case of star schema and incase of snow flake schema?
Ratings Rating:
View Answer View Answer: Here

Questions Question: What is difference between IIF and DECODE function
Ratings Rating:
View Answer View Answer: Here

Questions Question: What are variable ports and list two situations when they can be used?
Ratings Rating:
View Answer View Answer: Here

Previous Page 1 Page 2 Page 3 Page 4 Page 5 [ Page 6] Page 7 Page 8 Page 9 Page 10 Page 11 Page 12 Page 13 Page 14 Page 15 Page 16 Page 17 Page 18 Page 19 Next


 Sponsors  

Latest 10 Answers
When there is any situation that u should attach a new patch to ur kernel , then download the patch and install it,to make changes to kernel , go to ok prompt and type boot -r, it will update or reconfigure the kernel
Honesty, helpful and reliable
procedure is a set of sql statement ,are combined to gether to perform a specific task or to solve a specifi problem.it does not return value.
leadership is power to influence a group so that the members willingly exert efforts as aspired by the leader.
I have the unique combination of technical skill and the ability to build strong customer relationship. I have the ability to stay focussed in stressfull situation. I would be great addition to your team.
first execute the bc search spec to fetch the data then executes the applet search spec if applet search spec is not match with bc it skips
TCP-Transmission Control Protocol. TCP is Reliable. TCP is Connection oriented. UDP-User Datagram Protoco UDP is Unreliable. UDP is Connectionless.
By default in structure all data member and member function are public,i,e if you not mentation any access specifier. But in case of class By default all data member and member function are private.
Structure is a user defined data type. By default all structure variables are public type and we cann't use access specifier in structure type variable, where as in class we can define objects(variables) under required access specifier type.
variable cost is the cost which is not fixed in nature

Newinterviewquestions.com is a part of Vyom Network. Top



Copyright © 2017, newinterviewquestions.com. All rights reserved Privacy Policy | Terms and Conditions

Page URL: http://www.newinterviewquestions.com/cat/Informatica-interview-questions/Default.asp?&iType=18&iDBLoc=100&cachecommand=bypass


Download Yahoo Messenger | Web Hosting | Dedicated Server | Free SMS Domain Registration | Windows Hosting | Linux Hosting | Java Hosting | Virtual Dedicated Server | Dedicated Server | Reseller Web Hosting | Unlimited Windows reseller hosting | Unlimited Linux reseller hosting | Cheap Windows reseller hosting | Cheap Linux reseller hosting | Cheap Windows hosting | Best Windows hosting | Windows hosting Multiple Domains | Unlimited Windows hosting | Compare hosting plans | Cheap Linux hosting | Best Linux hosting | Linux hosting Multiple Domains | Unlimited Linux hosting | Cheap asp.net hosting | Best asp.net hosting | unlimited asp.net hosting | Cheap asp.net reseller hosting | Unlimited asp.net reseller hosting | Java Features | Cheap Java hosting | Best Java hosting | unlimited Java Hosting | Unlimited Linux reseller hosting | Java Hosting Multiple Domains Quick2host Reviews Buy Online Traffic