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
- 6282 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / zer0
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 |
Post New Answer View All Answers
What are the different options available for update strategy?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
What is the need for an etl tool?
How can we use mapping variables in informatica? Where do we use them?
Is stop and abort are same in informatica?
how to create user defined function (udf) in informatica
How do you remove duplicate records in informatica? And how many ways are there to do it?
What are the new features of Power Center 5.0?
Name the different lookup cache(s)?
As union transformation gives UNION ALL output, how you will get the UNION output?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Difference between Data and Index Caches?
can anyone suggest best free Talend data integration training online
What are the components of workflow manager?
What are the popular informatica products?
