in informatica,if i have some no.of records,if i want 1st
and 10th records..what will be the method to use?
Answer Posted / pavana
You can use sequence generator and then in exp trn, use a
variable which reads the 1st number the seq generates and
use filter transformation and take only 1st generated row
and +10th record.
| Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
Explain how many types of dimensions are available in informatica?
Why filter transformation is an active one?
While migrating the data from one environment to another environment how would you manage the connections?
Can we create multiple integration service on single repository?
How can we use batches?
in reporting we add some new objects,how we get the count of the newly added objects to the report
Explain what are the different versions of informatica?
What is a filter transformation and why it is an active one?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Scheduling properties,whats the default (sequential)
Write the program through which the records can be updated?
What does cheating measurement mean?
scenario where i can use only concurrent execution of workflow.
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is the function of union transformation?