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
- 15024 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
What are multi-group transformations?
What is the use of source qualifier?
scenario where i can use only concurrent execution of workflow.
Explain pushdown optimization and types in informatica
generate date / time dimension in informatica
How can we use mapping variables in informatica?
What does update strategy mean, and what are the different option of it?
How to differentiate between the active and passive transformations?
is it possible to index the data in cache of lkp transformation ?
Explain lookup transformation in informatica
Explain direct and indirect flat file loading (source file type) - informatica
Target increases every day even though no new record was inserted
What is a filter transformation?
How might one distinguish in the case of mapping is right or not without associating session?
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?
