"To get the first 100 rows from a flat file into the target, you can u

Explain how to get the first 100 rows from the flat file into the target?

Question Posted / Arun Kumar Rao

1 Answers
1049 Views
I also Faced
E-Mail Answers

Answer Posted / Arun Kumar Rao

"To get the first 100 rows from a flat file into the target, you can use a SQL statement with the LIMIT clause. For example, in SQL Server: SELECT TOP 100 * FROM file_name; In MySQL: SELECT * FROM file_name LIMIT 100;"

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1044

What is the purpose of Dataware Control?

1121

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2344

Explain how to generate iqd file from framework manager?

1022

does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

6077