How to send first half record to target?
Solution:
1. Drag and drop the source to mapping.
2.Step:2 In source-Qualifier , go to property and write the SQL query like
?
1select * from emp where rownum <= ( select count(*)/2 from emp)
3. Then connect to target.Now you are ready to run the mapping to see it in action.
Saturday, December 8, 2012
Sending first half record to target
Subscribe to:
Post Comments (Atom)
Tags
Architecture of UNIX
(1)
Basic Unix Commands
(1)
Data warehousing Quiestions1
(1)
Debugger
(1)
Downloads
(1)
ETL Process
(1)
Fundamentals of UNIX
(1)
Get top 5 records to target without using rank
(1)
Home
(1)
How do you perform incremental logic or Delta or CDC
(1)
Incremental Loading for Dimension Table
(1)
Informatica Complete Reference
(1)
Informatica Functions
(1)
Informatica Powercenter Architecture
(1)
informatica project
(1)
Informatica Quiestions
(1)
Informatica Quiestions3
(1)
Informatica Real time Scenarios
(2)
Informatica scenarios
(3)
Integration Testing
(1)
Introduction of Unix
(1)
Oracle Queries
(1)
Power center Client
(1)
Separate rows on group basis
(1)
TESTING-User Acceptance Test
(1)
Unit Testing
(1)
Unix
(2)
What is informatica
(1)
This article is very nice and informative to learners
ReplyDeleteInformatica training, informatica training in bangalore, informatica online training