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 ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to implement security measures using repository manager?
What are the components of the workflow manager?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is the need of an ETL tool?
How we can create indexes after completing the load process?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
my source is junk data how will u remove that junk data by using unix please any one replay me
what is the Default Source Option For Update Strategy Transformation?
I have a flat file, want to reverse the contents of the flat file
Explain in detail about scd type 1 through mapping.
what is degenerated dimension?
Explain transaction control transformation in informatica
Can we create a Integration service without a Repository service and vice versa?
What are session parameters ? How do you set them?