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
- 6795 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 the difference between STOP and ABORT options in Workflow Monitor?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is meant by query override?
wat are deployement groups in informatica, how it will be used for developers
Design a mapping to load a target table with the following values from the above source?
How many input parameters can exist in an unconnected lookup?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What is informatica powercenter repository?
Where can we find the throughput option in informatica?
What do you understand by a term domain?
Please let me know how to make Data masking in informatica..
Enlist the tasks for which source qualifier transformation is used.
Explain the features of connected and unconnected lookup.
Explain the types of transformations?
What is fact table? Explain the different kinds of facts.
