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
Name the different lookup cache(s)?
where to store informatica rejected data? How to extract the informatica rejected data?
Did u used latest transformations of 8.6.0? for what?
What are mapplets?
Explain constraint based loading in informatica
What is decode in informatica?
Explain the informatica workflow?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
How we can use union transformation?
What are the new features of informatica 9.x at the developer level?
What is a code page?
what are the Methods For Creating Reusable Transformations?
can u any challenge your project?
what is degenerated dimension?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?