Informatica Interview Questions
Questions Answers Views Company eMail

how will you remove the duplicate records from flat file without using sorter?

7 16319

How to find from a source which has 10,000 records, find the average between 500th to 600th record?

3 8097

Without source how to insert record to target?

6 17431

How to jion 2 tables, without using any condition?

Amazon,

11 34210

How to compare Source and Target table, without using dynamic lookup?

4 9596

In joiner, how to load Master table in Target?

2 6924

Without using Lookup & Sequence Generator, How to generate Sequence?

CTS,

5 12310

Is it possible to have "5 source & 5 Target" in single mapping?

1 5719

How to update records in Target, without using Update Strategy?

3 10684

How to display null values on a target & non-null values on a target?

3 7788

How to extract original records at one target & Duplicate records at one target?

12 18823

How to get EVEN & ODD numbers separately?

8 24204

How to retrieve last two days updated records?

4 9137

In a table, 4 person having same salary. How to get Third person record only?

15 17893

How to merge First Name & Last Name?

8 16999


Post New Informatica Questions

Un-Answered Questions { Informatica }

How are the sources and targets definitions imported in informatica designer?

661


How to load last n records of file into target table - informatica

586


How might you approve all mappings in the archive all the while?

590


What is a transaction control transformation?

752


What is difference between a gateway node and worker node?

607






Different sorts of metadata that stores in the storage facility?

544


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

6340


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

1683


On which transformations you created partitions in your project?

748


What is the format of informatica objects in a repository?

588


What is event and what are the tasks related to it?

598


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

596


Name the different lookup cache(s)?

688


What are the main features of Oracle 8i with context to datawarehouse?

1668


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

537