Sunday, January 29, 2023

Create a View in Oracle

›
A view in Oracle is a virtual table that represents data from one or more tables. It can be used to simplify complex data queries, aggregate...

Java Transformation in Informatica

›
Java Transformation in Informatica is a powerful tool that enables you to perform complex transformations within the Informatica PowerCenter...
Thursday, May 21, 2020

Oracle Programming Advanced

›
Lets see a Simple procedure in this post. Below is the code for a simple procedure which Queries the database and display the record when...

Oracle SQL Programming Basics

›
Lets learn the basic of Oracle Programming in this blog Select statement to query a table Select * from emp; Select * From Dept ; Here...
Friday, May 15, 2020

Vlookup in Excel

›
Here is how we do Vlookup in Excel Lets Say this is the Lookup table from where we want to get the Information Name Salary Age ...
Thursday, February 28, 2013

Unix Script to Copy a file in Informatica

›
Lets now see the steps involved in Copying a file and placing in a destination required using the unix script from informatica. 1) Create...

Unix Script to Create a empty file in Target

›
Lets see the steps involved in creating a empty file in the target folder using the unix script. 1) Create a Command Task in the Workflow...
1 comment:
Saturday, February 23, 2013

Pre Session Command in Informatica

›
Lets see how Pre session command can be given in a Informatica Workflow. The Below Screen shows a session where the pre session command ...
1 comment:
Thursday, November 15, 2012

scenario6

›
I have a scenario where i need to load a table called "name_address" first for storing all the claimant name with a generation of...

Scenario5

›
Source                Col_1    Col_2        D1       A1           D1       A2           D2       A3          D2       A4            D2   ...

Create different flatfiles as output

›
We have a scenario in our project where i have to create different flatfiles as output based on the company number The issue is  1) we r...
1 comment:
Wednesday, November 14, 2012

Java Transformation scenario2

›
Here i will show the mapping for scenario where we need the input records from emp table to be inserted into target thrice.     One...

Java Transformation

›
Let me show the Simple mapping involving Java transformation Here the source is emp table and the target is rangasp table in oracle. ...
Tuesday, November 13, 2012

Scenario 4

›
Input : empno    ename    job 7219     Sri      CLERK 7782     Uma    MANAGER 7839     Ragu   PRESIDENT 7934     Sendil   CLERK Output ...

Transaction control Transformation

›
Lets discuss about transaction control transformation in this video : I will show you a scenario using transaction control statement and ...