Interested to Buy Any Domain ? << Click Here >> for more details...
in informatica,if i have some no.of records,if i want 1st
and 10th records..what will be the method to use?
- 11 Answers
- 34911 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / sathish
source may be flat file or database just you use sequence ganarater then filter copy the nextval port to filter write condition nextval=1 or nextval=10 you get only 1 and 10 th records
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
explain about unit testing? in real time?
Informatica settings are available in which file?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is sq transformation?
How do you migrate data from one environment to another?
How do you set a varible in incremental aggregation
What you know about transaction control transformation?
Explain the features of connected and unconnected lookup.
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is olap (on-line analytical processing?
How to generate or load values in to the target table based on a column value using informatica etl tool.
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How might one distinguish in the case of mapping is right or not without associating session?
What is meant by pre and post session shell command?
What does command task mean?
