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
Could you explain what is enterprise data warehouse?
Explain the types of lookup transformation?
draw informatica architecture 8.6 ?
What is workflow? What are the components of workflow manager?
What are the differences between oltp and olap?
What are the types of lookup transformation?
Explain the different lookup methods used in informatica?
Explain scd type 3 through mapping.
What are the popular informatica products?
Explain lookup transformation source types in informatica
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Which is the t/r that builts only single cache memory?
Explain the different kinds of facts.
What are the databases that informatica can connect to windows?
What are the performance considerations when working with aggregator transformation?