Answer Detail: RE: how to get the first 100 rows from the flat file i...

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Print |

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

November 11, 2005 08:29:22	#3
Gooty Sreenivasulu	Database Expert Member Since: November 2005 Total Comments: 1
RE: how to get the first 100 rows from the flat file i...
I'd copy first 100 records to new file and load. Just add this Unix command in session properties --> Components --> Pre-session Command head -100 <source file path> > <new file name> Mention new file name and path in the Session --> Source properties.