How to delete first 3 rows & last 3 rows in target table in
informatica
- 6 Answers
- 12814 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 ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the benefit of partitioning a session?
What the difference is between a database, a data warehouse and a data mart?
What is Session and Batches?
What are the types of data warehouses?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What is a transaction control transformation?
What is the function of aggregator transformation?
How do you load alternate records into different tables through mapping flow?
Target increases every day even though no new record was inserted
What do you understand by a term domain?
What are the tuning techniques you applied during your last project
What are the main issues while working with flat files as source and as targets ?
Can you generate sequence numbers without using the sequence generator transformation?
How are indexes created after completing the load process?
Explain your project of banking domian.
