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
What are the new features of Power Center 5.0?
can we override a native sql query within informatica? Where do we do it? How do we do it?
How to Create a folder using pmrep command?
How to create the source and target database connections in server manager?
How can we use batches?
Explain how many types of dimensions are available in informatica?
What are mapplets?
what is the Default Source Option For Update Strategy Transformation?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What are the main features of Oracle 8i with context to datawarehouse?
What is dimensional table?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
write a query to retrieve the latest records from the table sorted by version(scd)
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
What is the difference between source qualifier transformations source filter to filter transformation?