Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Informatica Interview Questions
Questions Answers Views Company eMail

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

7 14009

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

3 7021

Without source how to insert record to target?

6 14503

How to jion 2 tables, without using any condition?

Amazon,

11 30491

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

4 8240

In joiner, how to load Master table in Target?

2 5834

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

CTS,

5 10431

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

1 4964

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

3 9511

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

3 6639

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

12 15676

How to get EVEN & ODD numbers separately?

8 20606

How to retrieve last two days updated records?

4 7356

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

15 14025

How to merge First Name & Last Name?

8 14372


Post New Informatica Questions






Un-Answered Questions { Informatica }

Define pmcmd command?

166


Explain the aggregator transformation?

161


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

5220


What are 2 modes of data movement in Informatica Server?

197


What are the popular informatica products?

148






What is rank transformation?

160


What is the sql query overwrite in source qualifier in informatica

185


design of staging area?

1084


Scheduling properties,whats the default (sequential)

943


Explain the different lookup methods used in informatica?

156


What is meant by lookup transformation?

154


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

145


what is diff b/t sorter t/r and agg have the option sorter property...

1226


What is informatica? Why do we need it?

151


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

184