1
2
3
*
4
5
6
*
7
8
9
how to load records between two stars(*),
Answer Posted / krishna
Mapping
source - SQ -> Exp T/r -> Filter -> target
Exp t/r:
create 4 variable and 3 output ports.
v_curr,v_flag,o_filter,o_flag,v_count,v_prev,0_count
v_flag = iif(v_currnt = '*' OR v_prev = '*' or flag_v=1,
1,0)
v_count = iif(v_prev='*',count+1,count)
o_filter = iif(No!= '*',1,0)
o_flag = v_flag
0_count = v_count
filter t/r:
condition: o_flag=1 AND o_filter=1 AND 0_count!=2
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is dynamic cache?
How do you promote a non-reusable transformation to reusable transformation?
To import the flat file definition into the designer where should the flat file be placed?
Which files are created during the session rums by informatics server?
COM components can be used in Informatica
How to update a particular record in target with out running whole workflow?
What is the need of etl tools?
What is transformation?
In warehouses how many schemas are there?
what is the difference between informatica6.1 and infomatica7.1
can we override a native sql query within informatica? Where do we do it? How do we do it?
update strategy transformation in informatica
What are the new features of informatica 9.x developer?
explain about unit testing? in real time?
Tell me about MD5 functions in informatica