If a table contains 100 records we have to fetch 50-100
records from source to target?how
Answer Posted / vikash sharma
SELECT * FROM Tab_name
WHERE Record BETWEEN 50 AND 100;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
which one is better performance wise joiner or look up
Performance tuning( what you did in performance tuning)
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What are the main features of Oracle 8i with context to datawarehouse?
What are the different versions of informatica?
What is incremental aggregation?
In development project what is the process to follow for an etl developer from day1
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is a repository? And how to add it in an informatica client?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What does update strategy mean, and what are the different option of it?
Sequence generator, when you move from develoment to production how will you reset
How many ways are there to do 'remove duplicate records in informatica'?
Differentiate between joiner and lookup transformation?