suppose my source is
101 a
1o1 b
101 c
101 d
i want target like that 101 abcd how will u achive this
please give me the answer
Answer Posted / bhageerath
src->sq->exp->aggr->tgt
src(col1[int],col2[varchar])
sq(col1[int],col2[varchar])
exp(col1,,col2,v_col1,v_col2,o_col2) {v=variable port, o=output port}
imp:
{ v_col1=col1; v_col2=iif(col1!=v_col1, col2, v_col2||" "||col2); o_col2= v_col2}
aggr(col1,o_col2)
tgt(col1,col2)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How might one distinguish in the case of mapping is right or not without associating session?
Performance tuning in UNIX for informatica mappings?
How to elaborate tracing level?
Can we create multiple integration service on single repository?
Why sorter is an active transformation?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What differs when we choose the sorted input for aggregator transformation?
How to create the source and target database connections in server manager?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is a joiner transformation and why it is an active one?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
How can we use mapping variables in informatica?
What is dynamic cache?
Name at least 5 different types of transformations used in mapping design and state the use of each.?