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,

7750

Can i create a lookup table without cache.

iGate,

7 9304

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,

1749

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

IBM,

1789

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 5011

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

IBM,

1 2656

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

iGate,

1 5015

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 13105

what is normalizer transformation?

Wipro,

4 6278

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 }

how tokens will generate?

1722

what is the -ve test case in your project.

1841

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

596

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1440

What does reusable transformation mean?

661




What are the performance considerations when working with aggregator transformation?

667

Could you explain what is enterprise data warehouse?

545

Explain target update override in informatica

623

have u done any performance tuning? how u ll do?

1849

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1461

What are the modules in Power Center

1216

Explain sql transformation in script mode examples in informatica

590

I have a flat file, want to reverse the contents of the flat file

681

Enterprise data warehouse your projects phase by phase explain?

1444

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

1689

For More Un-Answered { Informatica } Questions Click Here