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: What are the different types of transformation available in informatica. and what are the mostly used ones among them
Ratings Rating:
View Answer View Answer: Here

Questions Question: I have a situation here to load the Table into informatica. I have 5 temporary tables as sources. They look like: Table1: (K - Key, N-Null, X,Y,Z - values) K1 X N N N N K2 X N N N N -------------------------- Table2: K1 N X N N N K2 N X N N N -------------------------- the other 3 tables are in the same way. But there can be a situation like any of the table can contain duplicates like: K1 X N N N N K1 Y N N N N -------------------------- This kind of records should be errored out. Because of this, we can't use aggregator/group by as we are not sure which one should be removed. How can we obtain this functionality in Informatica.
Ratings Rating:
View Answer View Answer: Here

Questions Question: What is a view? How it is related to data independence?And what are the different types of views,and what is Materialize view
Ratings Rating:
View Answer View Answer: Here

Questions Question: Can you tell me how to go for SCD's and its types.Where do we use them mostly
Ratings Rating:
View Answer View Answer: Here

Questions Question: When do you we use dynamic cache and when do we use static cache in an connected and unconnected lookup transformation
Ratings Rating:
View Answer View Answer: Here

Questions Question: Can any one tell me how to run scd1 bec it create two target tables in mapping window and there are only one table in warehouse designer(means target).. so if we create one new table in target it gives error..
Ratings Rating:
View Answer View Answer: Here

Questions Question: How to export mappings to the production environment?
Ratings Rating:
View Answer View Answer: Here

Questions Question: How u will create header and footer in target using informatica?
Ratings Rating:
View Answer View Answer: Here

Questions Question: What is the difference between constraind base load ordering and target load plan
Ratings Rating:
View Answer View Answer: Here

Questions Question: How do we analyse the data at database level?
Ratings Rating:
View Answer View Answer: Here

Questions Question: Why sorter transformation is an active transformation?
Ratings Rating:
View Answer View Answer: Here

Questions Question: How is the union transformation active transformation?
Ratings Rating:
View Answer View Answer: Here

Questions Question: There are 3 depts in dept table and one with 100 people and 2nd with 5 and 3rd with some 30 and so. i want to diplay those deptno where more than 10 people exists
Ratings Rating:
View Answer View Answer: Here

Questions Question: What is tracing level?
Ratings Rating:
View Answer View Answer: Here

Questions Question: Can we eliminate duplicate rows by using filter and router transformation ?if so explain me in detail .
Ratings Rating:
View Answer View Answer: Here

Questions Question: How can we join 3 database like Flat File, Oracle, Db2 in Informatrica..
Ratings Rating:
View Answer View Answer: Here

Questions Question: Is a fact table normalized or de-normalized?
Ratings Rating:
View Answer View Answer: Here

Questions Question: I was working in SQL server, now i got an golden opertunity to work in INFORMATICA. I have lots of (silly) Questions to build my Career, so pls guide me properly. I will ask lots of questions.... What is the process flow of informatica,
Ratings Rating:
View Answer View Answer: Here

Questions Question: What is the difference between PowerCenter 6 and powercenter 7?
Ratings Rating:
View Answer View Answer: Here

Questions Question: my source is having 1000 rows. i have brought 300 records into my ODS. so next time i want to load the remaining records. so i need to load from 301 th record. when ever i start the work flow again it will load from the begining. how do we solve this problem.
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=220&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