Interested to Buy Any Domain ? << Click Here >> for more details...
1
2
3
*
4
5
6
*
7
8
9
how to load records between two stars(*),
- 10 Answers
- 14043 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is joiner change?
Quickly characterize reusable change?
What are the different types of repositories created using informatica?
Which development components of informatica have the highest usage?
Is stop and abort are same in informatica?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Define Pmrep command?
How do you take back up of repository?
What is sq transformation?
On which transformations you created partitions in your project?
What are some examples of informatica etl programs?
What is the difference between informatics 7x and 8x and what is latest version?
What does command task mean?
What are the advantages of using informatica as an etl tool over teradata?
