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
- 14485 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
complex mapping ur project u r invlve can u explain and give real time example give me ?
Enterprise data warehouse your projects phase by phase explain?
What is decode in static cache?
Define mapplet?
What is the advantage of informatica?
What is the commit type if you have a transaction control transformation in the mapping?
What are the differences between a connected lookup and unconnected lookup?
Please let me know how to make encryption and decryption with example?
What is parallel processing in informatica?
draw informatica architecture 8.6 ?
Could you explain what is enterprise data warehouse?
When do you use sql override in a lookup transformation?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How union transformation is used?
