Interested to Buy Any Domain ? << Click Here >> for more details...
How to eliminate 1st and last rows from the source and load
the inbetween rows.
- 5 Answers
- 26229 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / allen
Skipping the firt row in a flat file is easy:
The PowerCenter Server skips the specified number of rows
before reading the file. Use this to skip title or header
rows in the file.
Skipping the last row is not as easy. In my case, the last
row was a record count. I was able to check ports that
shouldn't be null, spaces or zeros and reject the row. The
LENGTH function can also be used to check the length of
data. Delimited or not has to be considered in any checks.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the informatica workflow?
What can we do to improve the performance of informatica aggregator transformation?
What are roles and groups and benefits of using them?
What is joiner change?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
r u done any partitions in ur project?
Define sessions in informatica etl?
What do you mean incremental aggregation?
What is difference between a gateway node and worker node?
What is the command used to run a batch?
What is dimensional table? Explain the different dimensions.
What is informatica metadata and where is it stored?
How to go to the older version for a mapping?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
