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

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

 548

How does a rank transform differ from aggregator transform functions max and min?

 665

What is xml source qualifier transformation in informatica?

 709

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

 782

What differs when we choose the sorted input for aggregator transformation?

 566

What do you understand by term role-playing dimension?

 568

What is parallel processing in informatica?

 1023

What is meant by lookup transformation? Explain the types of lookup transformation?

 565

What if the source is a flat-file? Then how can we remove the duplicates from flat file source?

 1 808

WHat all joins are there in Source Qualifier?

 1 1765

What all join we can perform in LOOKUP transformation?

 559

Difference between Target-based loading and constraint-based loading?

 548

Different circumstance which drives informatica server to expel records?

 549

Separate from an archive server and a powerhouse?

 490

Make a note of the quantity vaults made in informatica?

 549

Post New Informatica Questions

Un-Answered Questions { Informatica }

How to generate sequence numbers without using the sequence generator transformation?

637

What is aggregator transformation in informatica?

539

Which transformation should we use to normalise the COBOL and relational sources?

737

What is informatica etl tool?

548

Explain the use of aggregator cache file?

670




Is it possible to define a single node as a Gateway node as well as worker node?

650

When do you use sql override in a lookup transformation?

579

Separate from an archive server and a powerhouse?

490

What are the reusable transformations?

693

Explain your project of banking domian.

1214

How to configure mapping in informatica?

673

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

3438

What are the differences between oltp and olap?

546

Mention a few design and development best practices for informatica?

555

wf dont have integration severances how you can run?

1539

For More Un-Answered { Informatica } Questions Click Here