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
What is the use of an aggregator cache file?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is a transaction control transformation?
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?
COM components can be used in Informatica
Explain scd type 3 through mapping.
What are the main issues while working with flat files as source and as targets ?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Differentiate between Load Manager and DTM?
What is a repository manager?
Explain the mapping variable usage example in informatica
Describe data concatenation?
How you can differentiate between connected lookup and unconnected lookup?
How to do unit testing in informatica? How to load data in informatica ?
where to store informatica rejected data? How to extract the informatica rejected data?