Interested to Buy Any Domain ? << Click Here >> for more details...
Hi Experts , Can you please help me regarding the below
question How to remove first three rows and last three rows
in informatica.. thanks and regards Natraj
- 2 Answers
- 6755 Views
- I also Faced
- E-Mail Answers
Answer Posted / rampriya
To skip first n of lines,
If source is DB, then use
select * from emp_details where rownum>3
If the source is flat file, then set Number of Initial lines
to skip=3 in session level property
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
How can repository reports be accessed without sql or other transformations?
Implementation methodology
What is the procedure for creating independent data marts from informatica 7.1?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
explain about unit testing? in real time?
On which transformations you created partitions in your project?
What is a stored procedure transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What are the main features of Oracle 8i with context to datawarehouse?
How can informatica be used for an organization?
What is repository manager?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Describe expression transformation?
What is the meaning of decode in informatica?
What is Session and Batches?
