Oracle Business Intelligence Application Architect
☎ +91 9994883085
Don't miss

Friday, 19 June 2015

Informatica Real time Scenarios List


By on 04:01:00


The article  prepared by Tazeen Zehra from Bangalore on informatica real time scenarios.
 This scenarios questions has been prepared for the informatica developers and freshers who working in Informatica.



1)How to Separate duplicate values and distinct values from source by using aggregator transformation

2)How To Load Top 5 Records based on SAL without Using RANK transformation in Informatica

3)How to load every 4th record into target table in Informatica

4)How to load data based on even and odd record numbers in Informatica

5)Salary incrementing based on department by using router with expression

6)How to generate sequence number without using sequence generator transformation in informatica
Informatica Real time Scenarios List
Informatica Real time Scenarios List

7)Top 5 highly paid employees without using rank,sequence generator transformation in informatica

8)removing $ symbol from currency in informatica

9)Creating email from first name,last name,organization name in informatica

10)Creating first name, last name, organization name from email

11)How to convert dollar to rupee in informatica

12)How to find cumulative salary in informatica

13)How to load first record into one table second record into one table remaining will into another table

14)How to replace one character by another character by using replcachr function

15)How to load current sal for next extemployee

16)First salary as null and first row salary to second row in informatica

17)Top 10 salaries without rank

18)How to load numbers into one column alphabets into one column from single column

19)How to genarate sequence number for two target tables by using only one sequence generator

20)Mapping to load all records except last 5 records

0 comments:

Post a Comment

Labels

1z0-482 Dumps (2) 1Z0-525 Dumps (1) BI Apps Installation (1) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (46) Informatica Online Training (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) Normalization in Oracle (1) OBIA 11.1.1.7.1 (1) OBIA 7.9.6.3 (3) OBIA Installation (33) OBIEE (1) OBIEE 10G (8) OBIEE 11G (137) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)