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

How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks

Puma,

2 5937

What is flashback table ? Advance thanks

Puma,

1473

what are the limitations of pushdown optimization technique ? Advance thanks

Puma,

3 39171

What is version control in informatica ? Advance thanks

HCL, Puma,

6 15733

How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)

Puma,

6 8448

Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation

Puma,

1 13294

Can we write to_date(three arguments) ? Will it work ? Advance thanks

Puma,

1 5594

can we send mail when ever it get success or faulure to other mailid?(Not company mail id)

Puma,

1 3712

In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?

Puma,

4 7813

What is the difference between lookup override and souce qualifier override ?

Puma,

2 14604

As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?

 1 3452

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

 1626

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

 2 8866

What is the role of informatica in project ?Like i showed financial projects?

Amdocs,

1 2568

Why we require dwh in particular projects?

Amdocs,

1 4425

Post New Informatica Questions

Un-Answered Questions { Informatica }

How identifying bottlenecks in various components of informatica and resolving them?

572

What do mean by local and global repository?

689

How do you load only null records into target?

726

What is meant by pre and post session shell command?

610

What is target load order?

794




Enterprise data warehouse your projects phase by phase explain?

1444

Mention a few design and development best practices for informatica?

549

Explain how many types of dimensions are available in informatica?

577

How can we improve session performance in aggregator transformation?

660

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

1605

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

1837

explain about unit testing? in real time?

1646

What are the measure objects?

647

What is a shortcut and copy in Informatica and how two are different with each other?

666

What is meant by active and passive transformation?

574

For More Un-Answered { Informatica } Questions Click Here