how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
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
Different qualification between a related rotate toward the sky and isolates look upward?
What is the function of aggregator transformation?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
How can we use mapping variables in informatica? Where do we use them?
How are indexes created after completing the load process?
What is enterprise data warehousing?
Enterprise data warehouse your projects phase by phase explain?
What are the different versions of informatica?
Define Pmrep command?
What are the prerequisite tasks to achieve the session partition?
How we can use union transformation?
During the running session, output files are created by informatica server. Enlist few of them.
What is DR strategy for Informatica project?
Differentiate between sessions and batches?
How to create or import flat file definition in to the warehouse designer?