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

What are the differences between source qualifier and joiner transformation?

 594

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

 601

What are the types of schemas we have in data warehouse.

 527

Why update strategy and union transformations are active? Explain with examples.

 705

How do you remove duplicate records in informatica?

 1 711

How do you load alternate records into different tables through mapping flow?

 1287

How do you load first and last records into target table?

 662

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

 769

Explain in detail scd type 2 through mapping.

 609

How do you load unique records into one target table and duplicate records into a different target table?

 705

Explain the different kinds of facts.

 560

How do you load only null records into target?

 738

What is fact table? Explain the different kinds of facts.

 610

How many ways are there to do 'remove duplicate records in informatica'?

 583

How to join three sources using joiner? Explain though mapping flow.

 693

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is an expression transformation in informatica?

514

can we override a native sql query within informatica? Where do we do it? How do we do it?

595

How to implement security measures using repository manager?

600

What is pmcmd command?

670

Explain pushdown optimization $pushdownconfig parameter - informatica

698




COM components can be used in Informatica

1871

what is mean by complex business rule ?

1720

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

630

Explain scd type 3 through mapping.

576

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

596

The question was on time stamp. what is the difference between HH and HH24 when to use when.

1550

Write the unconnected lookup syntax and how to return more than one column.

590

can you please explain me pre session and post session options?

6366

Differentiate between Load Manager and DTM?

1662

How do you change a non-reusable transformation to reusable transformation?

592

For More Un-Answered { Informatica } Questions Click Here