If a table contains 100 records we have to fetch 50-100
records from source to target?how
Answer Posted / rajesh
use condition rownum>=50 in filter transformation
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
Difference between Target-based loading and constraint-based loading?
Sequence generator, when you move from develoment to production how will you reset
whats the logic to load the lower level of granularity of data to fact table.
What is Data Caches size?
How do you set a varible in incremental aggregation
what is the hint? how to use it to reduce the query processing in program?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Explain the difference between a data warehouse and a data mart?
What will be the approach?
How to load data in informatica ?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How can we remove the duplicates from flat file source?
Can we create two repositories on same database instance in oracle?
How do you change a non-reusable transformation to reusable transformation?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?