Interested to Buy Any Domain ? << Click Here >> for more details...
if we have certain records,if i need to get 5 th rec for the
first time to the target,when i run it for next time,i need
to get 6th rec...like that it should process.what wil be the
procedure to achieve it??
- 1 Answers
- 6144 Views
- IBM, I also Faced
- E-Mail Answers
I guess this should work ........
Source --> SQ --> Exp --> Filter --> Exp --> Target
|
|
SG
Firstly create a mapping variable say $$count and give it
the default value 5.
Create a port in Expression say Srno. and connect the
sequence generator to it (so that it will mark the rownums).
Then in Filter place the condition Srno = $$count
In the second Expression create an extra port and give it
the value SETCOUNTVARIABLE($$count) (this will increment
the mapping variable).
Next time the job runs it will take value of $$count as 6
and so on ........
Kindly revert if this worked ........
| Is This Answer Correct ? | 20 Yes | 1 No |
wt is informatica file watch timers in aflat i want to get the first record and last record how could i.
can we use cartesian join in informatica
What is meant by query override?
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
What are the tasks that can be performed using sq?
How to delete the data in the target table after loaded.
What is polling?
How many repositories can be created in informatica?
My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this
How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).
If u select groupby port in aggregator what is output and dont select groupby option what is output
get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c
Teradata 
