1
2
3
*
4
5
6
*
7
8
9
how to load records between two stars(*),
Answer Posted / guest
u can use mapping variable in exp transformation.
and do
decode(v_curr='*' or v_prev='*',setvariable($$,$$+1),$$)
and last port in exp setvariable($$,0) and accrdingly filter the non required...
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Whats the difference between informatica powercenter server, repositoryserver and repository?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What are the popular informatica products?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
which one is better performance wise joiner or look up
What is the different lookup cache(s)?
How you can differentiate between connected lookup and unconnected lookup?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
How do you use reject loader.
How can informatica be used for an organization?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
What is workflow monitor?
What is a predefined event?
How to call shell scripts from informatica?
What is sq transformation?