how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
- 2 Answers
- 6517 Views
- I also Faced
- E-Mail Answers
Answer Posted / triveni
source->sq->sequencegenerato->expression->filter->target
nextval to expressiontransformation
seq(output) decimal 10 nextval
startval=1,endvalue=14,cycle
mapping variable:$$var varible integer 10 o max
intialvalue=0
filter decimal 10
setvariable( $$seq,($$seq+1))
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What are the new features of informatica 9.x in developer level?
What are the new features of informatica 9.x at the developer level?
What is mapplet in informatica?
have u done any performance tuning? how u ll do?
Do you find any difficulty while working with flat files as source and target?
Please let me know how to make encryption and decryption with example?
What all join we can perform in LOOKUP transformation?
Why do we need informatica?
How to update a particular record in target with out running whole workflow?
what is the -ve test case in your project.
What are the new features of informatica 9.x developer?
In how many ways we can create ports?
What are the differences between source qualifier and joiner transformation?
what is degenerated dimension?
Sequence generator, when you move from develoment to production how will you reset
