1
2
3
*
4
5
6
*
7
8
9
how to load records between two stars(*),
- 10 Answers
- 12008 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / ankur saini
hey guys c if this works...
add an exp after source qualifier...with two more ports
v_out as variable =iif((is_number(inputport),0,v_out+1)
output=v_out
so output from this exp will be
1 0
2 0
3 0
* 1
....
* 2
...
now add a filter where output>0
Thanks
| 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?
What is the function of look up transformation?
Differentiate between a database and data warehouse?
What all join we can perform in LOOKUP transformation?
What are the main issues while working with flat files as source and as targets ?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Is there any target staging area in informatica not staging area
Define the various join types of joiner transformation?
What is Cognos script editor?
What are the tuning techniques you applied during your last project
Separate from a database, an information bazaar, and an information stockroom?
What are the differences between a connected lookup and unconnected lookup?
Define update strategy?
Briefly define a session task?
