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

Showing Answers 1 - 10 of 10 Answers

ravi

  • Oct 4th, 2005
 

by usning shell script

  Was this answer useful?  Yes

Rahiman

  • Oct 25th, 2005
 

please check this one,

task ----->(link)   session (workflow manager)

double click on link and type $$source sucsess rows(parameter in session variables) = 100

it should automatically stops session.

  Was this answer useful?  Yes

Gooty

  • Nov 11th, 2005
 

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.

  Was this answer useful?  Yes

Hemant Bhavsar

  • Apr 3rd, 2006
 

1. Use test download option if you want to use it for testing.

2. Put counter/sequence generator in mapping and perform it.

Hope it helps.

  Was this answer useful?  Yes

dl_mstr

  • Dec 30th, 2007
 

Use a sequence generator set  properties as reset and then use filter, put condition as NEXTVAL<=100 .

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions