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
- 6630 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 do you manage the Parameter files while migrating your data from one environment to another environment?
Briefly explain the aggregator transformation?
Differences between connected and unconnected lookup?
Design a mapping to load a target table with the following values from the above source?
Differentiate between joiner and lookup transformation?
How might one distinguish in the case of mapping is right or not without associating session?
What are the reusable transformations?
How are indexes created after completing the load process?
Could you explain what is enterprise data warehouse?
Which is the t/r that builts only single cache memory?
What is meant by incremental aggregation?
Plz can any one say me how to get the informatica certification materials and dumps
can we override a native sql query within informatica? How do we do it?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is the sql query overwrite in source qualifier in informatica
