SELECT * FROM Tab_name WHERE Record BETWEEN 50 AND 100;

If a table contains 100 records we have to fetch 50-100
records from source to target?how

Question Posted / vikash sharma

Answer Posted / vikash sharma

SELECT * FROM Tab_name
WHERE Record BETWEEN 50 AND 100;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1065

expain about the tune parameters?

2396

What is the way to execute pl/sql script using informatica mapping?

1582

write a query to retrieve the latest records from the table sorted by version(scd)

1051

What is data movement mode in Informatica and difference between them?

1118

Please let me know how to make encryption and decryption with example?

1886

Explain joiner transformation in informatica

1109

How many input parameters can exist in an unconnected lookup?

1531

Can anyone tell me the new features in Informatica 9 Version?

2103

What is Cognos script editor?

4206

explan ur project architecture?

2045

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1936

tell me the rules and responsblites in our project(my project is development)

1918

Explain what are the different versions of informatica?

1083

How do you change a non-reusable transformation to reusable transformation?

986