How to eliminate 1st and last rows from the source and load
the inbetween rows.
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
Can we create two repositories on same database instance in oracle?
What are mapplets?
How we can use union transformation?
What is informatica etl tool?
What are the different transaction levels available in transaction control transformation?
What is dynamic cache?
How do you update the records with or without using update strategy?
how we can load rejected record's at run time?(not through bad files)
What is a grid in Informatica?
What are the uses of etl tools?
What are active and passive transformations?
what is informatica metadata?
Where do we use mapping variables in informatica?
How to partition the Session?
What is complex mapping?