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
- 7316 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
While migrating the data from one environment to another environment how would you manage the connections?
What does update strategy mean, and what are the different option of it?
What is dynamic cache?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Is stop and abort are same in informatica?
What is the need for an etl tool?
How to partition the Session?
Have you worked with/created Parameter file
Define mapplet?
Enlist the advantages of informatica.
How to Create a folder using pmrep command?
can we override a native sql query within informatica? Where do we do it?
How many ways are there to create ports?
How are indexes created after completing the load process?
