INFORMATICA TUTORIAL Archives - Wings Of Technology

WHAT IS THE DIFFERENCE BETWEEN NORMAL AND BULK LOADING IN INFORMATICA?

Admin May 29, 2019 INFORMATICA INTERVIEW QUESTIONS, INFORMATICA TUTORIAL

The main difference between normal and bulk load is, in normal load Informatica repository service create logs and in bulk load log is not being created. That is the …

[Continue Reading...]

WHAT IS A SHORTCUT IN INFORMATICA

Admin May 28, 2019 INFORMATICA TUTORIAL

In Informatica, the best practice is any object used in more than one folder should be created as a shortcut. A Shortcut is a pointer to where the “real” …

[Continue Reading...]

SQL OVERRIDE IN INFORMATICA

Admin May 27, 2019 INFORMATICA TUTORIAL

source-qualifier-transformation-informatica

For relational database sources, the PowerCenter Informatca Server generates a query for each Source Qualifier transformation when it runs a mapping. The default query is a SELECT statement for …

[Continue Reading...]

RANK TRANSFORMATION IN INFORMATICA

Admin May 26, 2019 INFORMATICA TUTORIAL

Rank transformation in Informatica is an active and connected transformation. The rank transformation is used to select the top or bottom rank of data. Rank transformation is equal to …

[Continue Reading...]