Gantry 5
  • Home
  • Joomla!
      • Back
      • Joomla! Tutorials
          • Back
          • Extension Tutorials
          • Random Articles On Joomla!
      • Tools
      • Extensions
          • Back
          • JooComments
  • Java
      • Back
      • Core Java
          • Back
          • Programming Interview
          • Random Articles
          • Basic Pogramming
          • Frequently Asked Interview Question
          • Collection Tutorials
          • SCJP/OCJP
          • Advanced Interview Questions
          • Data Structures
          • Reflection
      • Servlet & JSP
          • Back
          • Interview Questions
      • J2EE
          • Back
          • Random Articles
      • Struts2
          • Back
          • Tutorials
          • Interview Questions
          • Random Articles
      • EJB 3
          • Back
          • Interview Questions
          • Tutorials
      • Spring 3.0
          • Back
          • Tutorials
          • IOC walk-through
          • interview questions
      • Hibernate 3.6
          • Back
          • Tutorials
          • Interview Questions
      • Ajax
          • Back
          • Ajax with servlet,json
      • Android
          • Back
          • Tips and Tricks
          • Random android articles
      • Java OO & Design
          • Back
          • Interview Qustions
          • OOP tutorials
  • Database
      • Back
      • SQL Tutorial
          • Back
          • Select Query
          • SQL Joins
          • SQL Complex Queries
          • Oracle Literals
          • Types Of SQL Statements
          • Oracle constraints
          • View And Materialized View
          • Synonyms
          • Sequences
          • Sql Functions
          • Global Temporary Table
          • Set Operators
      • Tips And Tricks
      • Informatica
          • Back
          • Scenario
          • Informatica quiz
      • PL SQL
          • Back
          • Pl Sql Examples
      • BO
          • Back
          • BO Tutorial
      • CouchDB
      • MongoDB
          • Back
          • Study Notes
          • Tutorial
          • Shell cheat-sheet
      • Redis
          • Back
          • Redis Java Tutorials
  • Php
      • Back
      • PHP Basic Programming
  • Web
      • Back
      • JavaScript
          • Back
          • Mootools Tutorials
          • Extjs Tutorials
      • Testing
          • Back
          • Selenium
          • JMeter
      • AngularJS
          • Back
          • Interview Questions
  • Quiz
      • Back
      • Core Java Quiz
          • Back
          • Java Collections Part 1
          • Java Collections Part 2
          • Java Overriding Part 1
          • Java Overriding Part 2
          • Java Annotation
          • Java Strings Part 1
          • Java Strings Part 2
          • Java Strings Part 3
          • Java Coding Standard
          • Java Operator Part 1
      • Computer Awareness
          • Back
          • Computer Knowledge Set 1
          • Computer Knowledge Set 2
          • Computer Knowledge Set 3
          • Computer Knowledge Set 4
          • Computer Knowledge Set 5
          • Computer Knowledge Set 6
          • Computer Knowledge Set 7
          • Computer Knowledge Set 8
          • Computer Knowledge Set 9
          • Computer Knowledge Set 10
          • Computer Knowledge Set 11
          • Computer knowledge Set 12
          • Computer Knowledge Set 13
          • Computer Knowledge Set 14
          • Computer Knowledge Set 15
          • Computer Knowledge Set 16
          • Computer Knowledge Set 17
          • Computer Knowledge Set 18
          • Computer Knowledge Set 19
          • Computer Knowledge Set 20
          • Computer Knowledge Set 21
          • Computer Knowledge Set 22
          • Computer Knowledge Set 23
          • Computer Knowledge Set 24
          • Computer Knowledge Set 25
          • Computer Knowledge Set 26
          • Computer Knowledge Set 27
          • Computer Knowledge Set 28
          • Computer Knowledge Set 29
      • English Grammar
          • Back
          • Grammar Basic Set 1
          • Grammar Basic Set 2
          • Grammar Basic Set 3
          • Grammar Basic Set 4
      • Informatica Quiz
          • Back
          • Informatica Set 1
          • informatica set2
          • Informatica Set 3
          • Informatica Set 4
          • Informatica Set 5
          • Informatica Set 6
          • Informatica Set 7
          • Informatica Set 8
          • Informatica Set 9
          • Informatica Set 10
          • Informatica Set 11
          • Informatica Set 12
          • Informatica Set 13
          • Informatica Set 14
          • Informatica Set 15
      • Servlet And Jsp Quiz
          • Back
          • Servlet Basics Set 1
          • Servlet Basics Set 2
          • Servlet Basics Set 3
          • Servlet Basics Set 4
          • Servlet Basics Set 5
          • Servlet Basics Set 6
          • Servlet Advance Understanding Set 1
          • Servlet Advance Understanding Set 2
          • JSP Set 1
      • SQL Quiz
          • Back
          • Sql Fundamental Set 1
          • Sql Fundamental Set 2
          • Sql Fundamental Set 3
          • Sql DDL Statement Set 1
          • Sql DDL Statement Set 2
          • Sql DML Statement Set 1
          • Sql DML Statement Set 2
          • Sql DML Statement Set 3
          • Sql TCL and DCL Set 1
          • Sql TCL and DCL Set 2
          • SQL Operator Set 1
          • SQL Operator Set 2
          • SQL Operator Set 3
          • SQL Operator Set 4
          • SQL Group By Order By and Having
          • SQL Constraint 1
          • SQL Constraint 2
          • SQL Function 1
          • SQL Function 2
          • SQL Function 3
          • SQL Function 4
          • SQL Join 1
      • Java Miscellaneous
          • Back
          • Java Web Start
      • CSS3
          • Back
          • CSS3 Basic Set 1
          • CSS3 Basic Set 2
          • CSS3 Basic Set 3
          • CSS3 Basic Set 4
          • CSS3 Basic Set 5
      • Spring Quzzies
          • Back
          • Spring MVC
          • Spring IOC
      • MongoDB Quzzies
          • Back
          • Introduction Set 1
      • Scala
          • Back
          • Scala quiz 1
          • Scala quiz 2
  • Downloads
      • Back
      • Struts2 Downloads
      • Joomla Downloads
          • Back
          • Eclipse Plug-ins
          • Joomla! Components
          • Joomla! Modules
      • Hibernate
      • Ejb3 Download
  • Database
  • Informatica
  • Scenario

Informatica Scenarios Home

List of articles in category Informatica Scenarios Home
Title
Convert single row from source to three rows in target
Split the non-key columns to separate tables with key column in both
Separating duplicate and non-duplicate rows to separate tables
Retrieving first and last record from a table/file
Remove footer from your file
Remove header from your file
Sending first half record to target
Sending second half record to target
Sending alternate record to target
Separate the original records in target
Separate rows on group basis
Get top 5 records to target without using rank
Segregating rows on group count basis
Extracting every nth row
Sending records to target tables in cyclic order
Concatenation of duplicate value by comma separation
Target table rows , with each row as sum of all previous rows from source table.
Produce files as target with dynamic names
Validating all mapping in repository
Using mapping parameter and variable in mapping
Removing '$' symbol from salary column
Currency convertor
sending data one after another to three tables in cyclic order
Converting '$' symbol to 'RS." in sal column
Insert and reject records using update strategy
Count the no of vowel present in emp_name column
Remove special characters from empno
Convert Numeric Value to Date Format
Check the Hire-Date is Date or Not
Date Difference in Hours
Sending to target with days difference more than 2 days
Convert Day No. to corresponding month and date of year
Targeting records of employees who joined in current month.
Extracting first and last name
Extracting Middle Name From Ename
SCD TYPE1
SCD Type2
SCD Type3
Unit Testing
To Top