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
- 6658 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
What is rank transformation?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is the reusable transformation?
What is meant by target load plan?
What are the different types of transformation available in informatica.
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is informatica etl tool?
Explain scd type 3 through mapping.
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Explain why we use partitioning the session in informatica?
What is workflow monitor?
How can we use batches?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
how to create user defined function (udf) in informatica
