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
- 26435 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / kamlesh mishra
The PowerCenter Server skips the specified number of rows
before reading the file. Use this to skip header
rows in the file.
And for last rows implement following logic.
1) Take sorter transformation reverse the rows on the basis of some key field like empno.
2)take expr transformation add nextval from sequence generator
3) Take filter transformation add condition nextval !=1 .
4)(optional)reverse the rows again using sorter transformation.
5) From filter to tgt connect the respective ports.
Src---->SQ--->SORTER--->EXPR---->FILTER---->SORTER---->TGT
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How can we use mapping variables in informatica? Where do we use them?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
waht type of interface is used for testing the data in informatica
What is informatica? Why do we need it?
Explain incremental aggregation in informatica
What is the surrogate key?
What are the different clients of powercenter?
what is index?how it can work in informatica
What are the different lookup cache(s)?
How to load the data from a flat file into the target where the source flat file name changes daily?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
How do you migrate data from one environment to another?
What is a dimensional model?
How you know when to use a static cache and dynamic cache in lookup transformation?
Describe an informatica powercenter?
