SOURCE
1 a
1 b
1 c
2 a
2 b
2 c
TARGET
1 A B C
2 A B C
In oracle & informatica level how to achieve
- 4 Answers
- 7161 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / ankit kansal
Hi,
Using Informatica
SRC-SQ-SRT(key used id)-EXP(
v_name = IIF(ID=v_prev_id,v_prev_name ||' '||UPPER(name),UPPER(name))
v_prev_name = v_name
out_name = v_prev_name
v_prev_id = ID
)-AGG(group by id will give u last row)-TGT
Using Oracle
select value from (
select id ||' '||upper(name) ||' '|| lead(upper(name),1) over (partition by id order by id) ||' '|| lead(upper(name),2) over (partition by id order by id) value from ankit_temp order by 1
)temp where length(value)>0 order by value;
http://deepinopensource.blogspot.com/
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Design time, run time. If you don't create parameter what will happen
Can we create a Integration service without a Repository service and vice versa?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is informatica powercenter repository?
Informatica settings are available in which file?
Different qualification between a related rotate toward the sky and isolates look upward?
I have a flat file, want to reverse the contents of the flat file
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How to generate sequence numbers using expression transformation?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Describe the impact of several join conditions and join order in a joiner transformation?
In how many ways we can create ports?
What is the function of look up transformation?
what is diff b/t sorter t/r and agg have the option sorter property...
