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,

8223

Can i create a lookup table without cache.

iGate,

7 11649

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,

2199

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

IBM,

2276

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

IBM,

1 6660

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 5790

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

IBM,

1 3513

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

iGate,

1 5737

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

IBM,

6 10806

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 6829

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

IBM,

6 15179

what is normalizer transformation?

Wipro,

4 7913

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

Wipro,

4 11270

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

Cognizant, IBM,

2094

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 4386

Post New Informatica Questions

Un-Answered Questions { Informatica }

what is the difference between informatica6.1 and infomatica7.1

2276

Difference between Data and Index Caches?

1137

What are the tuning techniques you applied during your last project

2026

How to extract the informatica rejected data?

1220

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1975

What does reusable transformation mean?

1132

How are indexes created after completing the load process?

1644

6490

Is it possible to define a single node as a Gateway node as well as worker node?

1122

Explain sessions?

1064

What is workflow? What are the components of workflow manager?

1177

Can we create a node as a gateway node and the same node can be assigned to a grid?

1079

What is primary and backup node?

1127

Explain how to import oracle sequence into informatica?

1011

can you please explain me pre session and post session options?

7564

For More Un-Answered { Informatica } Questions Click Here