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


Please Help Members By Posting Answers For Below Questions

What are the main issues while working with flat files as source and as targets ?

646


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1493


how to load dimension table and fact table. plz tell me the steps.

1680


what is the size of your data warehousing?

1669


What are the differences between oltp and olap?

546






Define joiner transformation?

588


Explain where to store informatica rejected data? How to extract the informatica rejected data?

574


What is depict expression change?

614


if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

1757


How do you load only null records into target? Explain through mapping flow.

1493


What are active and passive transformations?

645


TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1462


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

6069


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

1843


What is status code in informatica?

582