1
2
3
*
4
5
6
*
7
8
9
how to load records between two stars(*),
- 10 Answers
- 12605 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
Describe the impact of several join conditions and join order in a joiner transformation?
What do you mean by worklet?
Under which circumstances, informatica server creates reject files?
What is the need for an etl tool?
Target increases every day even though no new record was inserted
How we can create indexes after completing the loan process?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Why filter transformation is an active one?
Which transformation should we use to normalise the COBOL and relational sources?
Sequence generator, when you move from develoment to production how will you reset
What is a snowflake schema?
Explain about cumulative Sum or moving sum?
In warehouses how many schemas are there?
explain one complex mapping with logic? sales project?
If informatica has its scheduler why using third party scheduler?
