Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7299 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 is substr in informatica?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Can we create a node as a gateway node and the same node can be assigned to a grid?
what is the -ve test case in your project.
What do you understand by term role-playing dimension?
Reusable transformation and shortcut differences
What are junk dimensions?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Explain what are the different versions of informatica?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is persistent lookup cache?
What is joiner change?
Where are the source flat files kept before running the session?
Explain how many types of dimensions are available in informatica?
