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
- 25931 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 do you mean by blocking transformation?
How to start a workflow using pmcmd command?
What is transformation?
Under which circumstances, informatica server creates reject files?
What are the prerequisite tasks to achieve the session partition?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Difference between Data and Index Caches?
What is the difference between stop and abort in informatica
Different circumstance which drives informatica server to expel records?
Explain load alternative records / rows into multiple targets - informatica
Separate from a database, an information bazaar, and an information stockroom?
Why do you use Mapping Parameter and mapping variable?
Explain the scenario which compels informatica server to reject files?
What are the different types of olap? Give an example?
EXL informatica Questions
