how remove 1st 3 records & last 3 records in informatics
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / gyana
yes..very nice question
---------------------------
after SQ take two pipeline::::one to find 1st 3 record and another to find last 3 record
------------------------------------------
(1) from SQ connect an expression and into that expression connect a sequence generator to generate sequence.
After expression put a filter t/r (seq>=4) and pass to one target instance(T1)
(2) from SQ connect an expression and into that expression connect a sequence generator to generate sequence.
now take a RANK t/r and set the property as(bottom performer,rank on port SEQ,NUMBER OF rank=3).connect that to second target instance (T2)..it will give u last 3 records..
if any wrong pls send me mail......(gyana.informatica@gmail.com)
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / shaik
if i don't want to change the order of source data,then how
can we perform.....
| Is This Answer Correct ? | 0 Yes | 2 No |
2 pipelines,1st pipeline sorter t/r ascending order then
rank t/r top3
2nd pipeline sorter decending order then rank top3 t/r
| Is This Answer Correct ? | 2 Yes | 7 No |
What is an unconnected transformation?
What did you do in source pre load stored procedure
My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify
What is meant by active and passive transformation?
i have two source data there is no pk,fk how to join the two sources
Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.
How can u insert o ne row in the target if that row does not exists in the target and update if it exists
If there are more than one sessions running parallel in a worklet, which will be the last session ?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What are the diffrences between joiner transformation and source qualifier transformation?
What are mapplets?
Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?
6 Answers iFlex, Morgan Stanley,