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

Write the unconnected lookup syntax?

 654

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

 590

How do you remove duplicate records in informatica? And how many ways are there to do it?

 711

What is dimensional table? Explain the different dimensions.

 653

What are the types of caches in lookup?

 564

What are the types of caches in lookup? Explain them.

 547

Differentiate between router and filter transformation?

 610

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

 1049

What are the differences between oltp and olap?

 546

What are the types of schemas we have in data warehouse and what are the difference between them?

 517

Differentiate between reusable transformation and mapplet.

 568

Why update strategy and union transformations are active?

 589

What is meant by target load plan?

 552

How to join three sources using joiner?

 569

How do you update the records with or without using update strategy?

 660

Post New Informatica Questions

Un-Answered Questions { Informatica }

what is song in infrmatica...?

1672

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1699

Can we override a native sql query within informatica?

626

What happens when a session fails and you click on recover?

653

What is native users?

721




If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1551

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

1964

What is a grid in Informatica?

605

Reusable transformation and shortcut differences

1371

tell me about your project functionality

1862

Please let me know how to make encryption and decryption with example?

1462

What is the Process to creating lookup transformation in informatica

581

where to store informatica rejected data? How to extract the informatica rejected data?

597

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

707

Write the unconnected lookup syntax?

654

For More Un-Answered { Informatica } Questions Click Here