Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete first 3 rows & last 3 rows in target table in
informatica
- 6 Answers
- 14744 Views
- TetraSoft, I also Faced
- E-Mail Answers
Answer Posted / venkateshmalneni
FIRS PIPELINE
BY using sequence generator t/r generate sequence
numbers(sno)
in rank t/r,from sq connect all the ports to the rank
t/r,rank by sno,select top 3 ranks
SECOND PIPELINE
connect the nextval port from sequence generator to sorter
t/r
from sq connect all the ports to the sorter t/r,connect all
the ports to the filter t/r.in filter t/r write a condition
sno>3.
connect the o/p of the two pipelines by using UNION T/R
connect the o/p of the Union t/r to aggrigator t/r group by
sno.create an o/p port with name count_sno to
count(sno),connect the o/p from aggrigator t/r to the filter
t/r write the condition count_sno=1.
connect the o/p from filter to trg
THE DATA FLOW DIAGRAM IS LIKE THIS
sequence generator
| |
| \|/
src--->sq--->rank------>union--->aggrigator---->filter->trg
| | /
\|/ \|/ /
sortet----->filter/
If am wrong please let me know
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Repository user profiles
What is Cognos script editor?
Where do we use mapping variables in informatica?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is decode in static cache?
What is domain and gateway node?
Explain direct and indirect flat file loading (source file type) - informatica
What is dimensional table?
What is lookup transformation?
What is the use of target designer?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What are batches?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is an aggregator transformation?
What are the differences between joiner transformation and source qualifier transformation?
