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
What is the fact table?
What do mean by local and global repository?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What is meant by lookup transformation? Explain the types of lookup transformation?
What are 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?
Differentiate between reusable transformation and mapplet.
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is an Integration service in Informatica?
what is size of u r database?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Does an informatica transformation support only aggregate expressions?
wat are deployement groups in informatica, how it will be used for developers
What are Dimensional table?