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
How to extract the informatica rejected data?
How can we update a record in the target table without using update strategy?
What is rank transformation in informatica
Performance tuning in UNIX for informatica mappings?
Which version configuration tool used in ur project?
Explain pushdown optimization $pushdownconfig parameter - informatica
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?
What do you understand by SOA of Informatica?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Differentiate between source qualifier and filter transformation?
When do you use sql override in a lookup transformation?
What is workflow? What are the components of the workflow manager?
Explain load alternative records / rows into multiple targets - informatica
Have you worked with/created Parameter file