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
Explain the different lookup methods used in informatica?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What are the guidelines to be followed while using union transformation?
tell me about your project functionality
What is the scenario which compels informatica server to reject files?
How do you update the records with or without using update strategy?
Differences between connected and unconnected lookup?
On which transformations you created partitions in your project?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is data caches/ index caches?
What is the difference between writing a joiner query in ANSI style and THETA style?
Define sessions in informatica etl?
What are the differences between a connected lookup and unconnected lookup?
scenario where i can use only concurrent execution of workflow.
Which development components of informatica have the highest usage?