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
- 6306 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
Did u used latest transformations of 8.6.0? for what?
have u done any performance tuning? how u ll do?
What is primary and backup node?
What is the use of transformation?
What is the different lookup cache(s)?
How to load last n records of file into target table - informatica
Performance tuning( what you did in performance tuning)
How might you approve all mappings in the archive all the while?
How to use pmcmd utility command?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What are the limitations of joiner transformation?
What is the status code in stored procedure transformation?
Explain load alternative records / rows into multiple targets - informatica
Explain what are the different types of transformation available in informatica.
Explain the mapping variable usage example in informatica
