Informatica and Boxi for Dummies

Search This Blog

Showing posts with label stored procedure. Show all posts

Monday, November 12, 2012

Create a Stored Procedure in Oracle

Please comment if you like the video

at 10:59 PM No comments:

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Labels: PL/SQL, Procedure, stored procedure

Import Stored procedure in Informatica

Please comment if you like the video.. Thanks!!!

at 9:37 PM No comments:

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Labels: stored procedure

Older Posts Home

Subscribe to: Posts (Atom)

Popular Posts

Scenario 3 - Aggregator Transformation Example

Input : Student Name Subject Name Marks Sam Maths 100 Tom Maths 80 Sam Physical Science 80 John Maths 75 Sam Life Science 70 John ...
Normalizer transformation scenario

How can we do this: StudentName Subject1 Marks1 Subject2 Marks2 Sam Maths 100 English 80 John Maths 85 English 75 to the target: Stu...
Scenario 2

Here we have a scenario to get the below mentioned output from the given input. Let us see how to solve this scenario : Input Employee ...
Source Qualifier Transformation and its Properties

Source Qualifier Transformation is an active Transformation. The reason is the output rows count can be modified by using option like ...
How to avoid Duplicate Rows in Informatica

Duplicate Rows in informatica can be avoided by selecting the distinct Check box in the Source Qualifier Transformation . If the Source ...
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 ...
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...
Connected Lookup vs Unconnected Lookup

Connected Lookup : 1) Connected Lookup can return more than one value.The number of Output port can be more than one. 2) The Cache will...
Joining Heterogeneous Sources

Joining Heterogeneous Sources can't be done using the Source Qualifier Transformation . Source Qualifier transformation is used to jo...
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...

Blog Archive

▼ 2023 (2)
- ▼ January (2)
  - Create a View in Oracle
  - Java Transformation in Informatica

► 2020 (3)
- ► May (3)

► 2013 (3)
- ► February (3)

► 2012 (34)
- ► November (10)
- ► October (16)
- ► August (1)
- ► July (7)

Total Pageviews

Powered by Blogger.