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
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What are the issues you have faced in your project? How did you overcome those issues?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
How can a transformation be made reusable?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Define filter transformation?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What all are steps in up gradation of Informatica server?
can anyone suggest best free Talend data integration training online
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Does an informatica transformation support only aggregate expressions?
What are mapplets?
What are the advantages of using informatica as an etl tool over teradata?
What you know about transaction control transformation?