1
2
3
*
4
5
6
*
7
8
9
how to load records between two stars(*),
Answer Posted / ankur
small change in the above post..
add an exp after source qualifier...with two more ports
v_out as variable =iif((is_number(inputport),v_out,v_out+1)
output=v_out
so output from this exp will be
1 0
2 0
3 0
* 1
4 1
5 1
6 1
* 2
7 2
8 2
8 2
now add a filter where output=1
Thanks
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What is DR strategy for Informatica project?
What is InformaticaPowerCenter?
What is the Rank index port in Rank transformation?
how many types of dimensions are available in informatica?
What are the mapping parameters and mapping variables?
What are the performance considerations when working with aggregator transformation?
update strategy transformation in informatica
What is sequence generator transformation in informatica?
Slowly changing dimensions, types and where will you use them
How do we call shell scripts from informatica?
what is the hint? how to use it to reduce the query processing in program?
What is a joiner transformation?
How to elaborate powercenter integration service?
What are the features of complex mapping?
What are the main features of Oracle 8i with context to datawarehouse?