How to delete first 3 rows & last 3 rows in target table in
informatica
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
What does refresh system mean, and what are its distinctive choice?
Could you explain what is enterprise data warehouse?
What is the meaning of up gradation of repository?
How are the sources and targets definitions imported in informatica designer?
What is a surrogate key?
What is a filter transformation?
Can we get 1st record through Informatica(without sequence number).
can any one give some examples for pre sql and post sql(Except dropping and creating index).
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What are the mapping parameters and mapping variables?
How to load data in informatica ?
What is the benefit of partitioning a session?
How does a sorter cache works?
What do you mean by blocking transformation?
What is domain in terms of informatica?