How to eliminate 1st and last rows from the source and load
the inbetween rows.
Answer Posted / maneesh
To eliminate first row, simply use a counter in Expression and then Filter.
To eliminate the last row, make two pipelines with the same source
In first pipeline, use AGGREGATOR without any Group By ports In second pipeline, join it with the above with JOINER. Use and Outer Join and then other than that Joined row .. load all the rows.
Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How many transformations can be used in mapplets.
explain abt ur project architecture?
Differences between version 7.x and 8.x.
What are the guidelines to be followed while using union transformation?
What are different types of transformations available in informatica?
if we have a delimiters at unwanted places in a flat file how can we over come those.
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What are multi-group transformations?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
wf dont have integration severances how you can run?
Explain what are the different types of transformation available in informatica.
Explain sessions?