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
- 26434 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
Is there any way to read the ms excel datas directly into informatica?
What do you mean by filter transformation?
What is intricate mapping?
What is the Rank index port in Rank transformation?
Explain the tuning lookup transformation - informatica
What is persistent lookup cache?
What is the function of union transformation?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Briefly define reusable transformation?
How to differentiate between the active and passive transformations?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How can we use mapping variables in informatica? Where do we use them?
can u any challenge your project?
What is the surrogate key?
State the differences between sql override and lookup override?
