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
- 26173 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
What is data movement mode in Informatica and difference between them?
What does command task mean?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Explain the difference between mapping parameter and mapping variable?
What are the new features of Power Center 5.0?
How would you join a node to the already existing domain?
What are the restrictions of union transformation?
What is the format of informatica objects in a repository?
How to join three sources using joiner?
What are the reusable transformations?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How to update or delete the rows in a target, which do not have key fields?
How to use pmcmd utility command?
can we override a native sql query within informatica? Where do we do it?
How can you increase the performance in joiner transformation?
