Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7981 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
How to update source definition?
How can we remove the duplicates from flat file source?
What is update strategy transform?
what is Active lock explain
Is there any target staging area in informatica not staging area
What do you understand by term role-playing dimension?
What is a predefined event?
what is diff b/t sorter t/r and agg have the option sorter property...
What do you mean by blocking transformation?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
EXL informatica Questions
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Is it possible to create multiple domains on a single Informatica server?
what are 3 tech challenges/ common issues you face?
What can we do to improve the performance of informatica aggregator transformation?
