1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category
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,

7749

Can i create a lookup table without cache.

iGate,

7 9301

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,

1745

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

IBM,

1785

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

IBM,

1 5945

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 5009

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

IBM,

1 2654

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

iGate,

1 5013

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

IBM,

6 8705

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 5694

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

IBM,

6 13099

what is normalizer transformation?

Wipro,

4 6272

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

Wipro,

4 9708

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

Cognizant, IBM,

1675

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 3682

Post New Informatica Questions

Un-Answered Questions { Informatica }

Slowly changing dimensions, types and where will you use them

1260

Explain the code page compatibility?

631

Difference between Target-based loading and constraint-based loading?

544

How are indexes created after completing the load process?

972

what is degenerated dimension?

3138




Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

1626

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5229

How can we delete duplicate rows from flat files?

730

How do you convert single row from source into three rows into target?

591

What is a transaction control transformation?

756

What are the different clients of powercenter?

587

What is a standalone command task?

643

What are roles and groups and benefits of using them?

561

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1610

What is lookup transformation?

575

For More Un-Answered { Informatica } Questions Click Here