Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Informatica Interview Questions

Questions Answers Views Company eMail

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

HCL,

8266

Can i create a lookup table without cache.

iGate,

7 11870

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

iGate,

2254

whats the logic to load the lower level of granularity of data to fact table.

IBM,

2318

What exactly mentioned in High level design document.can somebody explain me sequentialy.

IBM,

1 6734

if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.

IBM,

2 5907

How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.

IBM,

1 3590

whats the option in informatica 7 version is outdated in informatica 8 version onwards.

iGate,

1 5803

how can we load starting with 11th record of a table from source to target

IBM,

6 10995

can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?

IBM,

2 6930

can we load the data with out a primary key of a table? what is target plan?

IBM,

6 15390

what is normalizer transformation?

Wipro,

4 8122

how eliminate the duplicates in flat file with out using sorter ,aggregater

Wipro,

4 11462

how to load dimension table and fact table. plz tell me the steps.

Cognizant, IBM,

2149

how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.

1 4460

Post New Informatica Questions

Un-Answered Questions { Informatica }

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2514

How we can create indexes after completing the loan process?

1253

r u done any partitions in ur project?

1871

What does role playing dimension mean?

1098

What is informatica metadata and where is it stored?

1049

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1962

What is the format of informatica objects in a repository?

1079

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2108

how many types of dimensions are available in informatica?

1189

What is informatica etl tool?

1061

What are the new features of Power Center 5.0?

1853

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2077

Under what condition selecting sorted input in aggregator may fail the session?

1177

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1100

Can you generate sequence numbers without using the sequence generator transformation?

1167

For More Un-Answered { Informatica } Questions Click Here