how remove 1st 3 records & last 3 records in informatics

Answer Posted / venky

after sq transformation use exp transformation in that add
one port,and take seq generator trans and its properties
reset is enable,and link to the port in exp trans,after
that take filter trans and condition port>3,after that use
sorter trans in that take port desc,after that take exp
trans and create another new port,after that take seq gen
trans in properties resert as enable and link to the new
port,afer that use filter trans condition new port>3 and
connect to target.

this is the process u can do u wil get the result.pls try it
correctly

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the Process to creating lookup transformation in informatica

579


What is pmcmd command?

668


Design time, run time. If you don't create parameter what will happen

1422


What is the status code in stored procedure transformation?

683


Is there any way to read the ms excel datas directly into informatica?

546






One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

1743


How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1599


How does a sorter cache works?

563


list out all the transformations which use cache?

683


Can we create two repositories on same database instance in oracle?

604


Explain the different dimensions.

548


Explain sessions. Explain how batches are used to combine executions?

585


How to load the data from a flat file into the target where the source flat file name changes daily?

572


What is complex mapping?

633


can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2133