1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category
Informatica Interview Questions
Questions Answers Views Company eMail

why dimenstion tables are denormalized in nature ?

3 8455

What is the use of incremental aggregation?

 2 9072

What is the procedure to load the fact table.Give in detail?

 1 8068

what is a junk dimension ?

Atos Origin, Cognizant, HS, NIIT, TCS,

14 58100

What is the difference between Normal load and Bulk load?

 5 48490

Discuss the advantages & Disadvantages of star & snowflake schema?

 5 45032

what is a time dimension? give an example?

IBM,

2 11561

What are the reusable transforamtions?

 1 4344

What is aggregate cache in aggregator transforamtion?

5 8246

What are the basic needs to join two sources in a source qualifier?

 3 6196

In which circumstances that informatica server creates Reject files?

2 9251

Can you copy the session to a different folder or repository?

 2 10740

When the informatica server marks that a batch is failed?

 1 5151

What is a command that used to run a batch?

 2 6480

In a sequential batch can you run the session if previous session fails?

4 9470

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is DR strategy for Informatica project?

704

How many number of sessions can one group in batches?

696

How does the aggregator transformation handle null values?

703

What is the reusable transformation?

630

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

6485




Explain in detail scd type 2 through mapping.

619

Explain the pipeline partition with real time example?

656

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

1861

How do you set a varible in incremental aggregation

1451

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

1519

how many types of dimensions are available in informatica?

565

What is meant by lookup transformation?

616

Enlist some properties of sessions.

634

What is the session task and command task?

601

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

698

For More Un-Answered { Informatica } Questions Click Here