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
- 7172 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / parikhita prusty
first sort the first column empid using sorter t/r then
expersion t/r create variable port
v_ename:=iff(prev.empid=curr.empid,v_ename||' '||ename,ename)
o_ename=v_ename
then using expersion t/r convert lower case higher case. any
doubt mail me.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Separate from a database, an information bazaar, and an information stockroom?
According to his methodology what all you need before you build a datawarehouse
How to update source definition?
How to Create a folder using pmrep command?
What does “tail –f” command do and what is its use as an Informatica admin.
How to generate sequence numbers without using the sequence generator transformation?
What is standalone command task?
What is pmcmd command?
Why update strategy and union transformations are active? Explain with examples.
What are the components of workflow manager?
how to load rows into fact table in data warehouse
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 can a transformation be made reusable?
What are the issues you have faced in your project? How did you overcome those issues?
Clarify the aggregator change?
