Informatica Interview Questions
Questions Answers Views Company eMail

what is lookup ?

6 7034

what is the architecture of any Data warehousing project?

IBM,

4 10968

what is the flow?

1 3527




How to load time dimension?

Ford,

1 9464

In update strategy target table or flat file which gives more performance ? why?

7 14636

How do you create single lookup transformation using multiple tables?

TCS,

6 25581

Why touse stored procedure in ETL Application?

2 6538

How to improve the performance of Aggregate transformation?

Dmss,

3 7739




What is critical mapping?

2 5931

How to call stored Procedure from Workflow monitor in Informatica 7.1 version?

Accenture,

1 12631

How to view and Generate Metadata Reports?

1 3880

what is difference between COM & DCOM?

Satyam,

1 7391

what is the gap analysis?

1 5549

How to recover sessions in concurrent batches?

3 9598

what are the different types of transformation available in informatica and what are the mostly used ?

TCS,

3 17380


Post New Informatica Questions






Un-Answered Questions { Informatica }

How do you use reject loader.

860


What is confirmed fact in dataware housing?

3751


if we have a delimiters at unwanted places in a flat file how can we over come those.

653


what are 3 tech challenges/ common issues you face?

917


tell me the rules and responsblites in our project(my project is development)

525


what is diff b/t sorter t/r and agg have the option sorter property...

759


One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

865


Why do you use Mapping Parameter and mapping variable?

401


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

711


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?

571


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

290


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

633


Performance tuning in UNIX for informatica mappings?

1175


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

614


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

3388