GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Informatica
Go To First  |  Previous Question  |  Next Question 
 Informatica  |  Question 139 of 630    Print  
how to get the first 100 rows from the flat file into the target?

  
Total Answers and Comments: 5 Last Update: December 30, 2007     Asked by: sarath 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
October 04, 2005 01:07:33   #1  
ravi        

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

by usning shell script


 
Is this answer useful? Yes | No
October 25, 2005 02:54:22   #2  
Rahiman        

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

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.


 
Is this answer useful? Yes | No
November 11, 2005 08:29:22   #3  
Gooty Member Since: November 2005   Contribution: 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.

 
Is this answer useful? Yes | No
April 03, 2006 14:20:24   #4  
Hemant Bhavsar        

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

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.


 
Is this answer useful? Yes | No
December 30, 2007 18:12:31   #5  
dl_mstr Member Since: November 2007   Contribution: 26    

RE: how to get the first 100 rows from the flat file into the target?
Use a sequence generator set  properties as reset and then use filter, put condition as NEXTVAL<=100 .
 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape