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
- 6137 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
Explain the difference between a data warehouse and a data mart?
Explain pushdown optimization $pushdownconfig parameter - informatica
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Explain the types of transformations?
What are the different transaction levels available in transaction control transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is sq transformation?
What is the way to execute pl/sql script using informatica mapping?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Can u generate reports in Informatica?
What is a passive transformation?
What is parallel processing in informatica?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
waht type of interface is used for testing the data in 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?
