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
- 7945 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
What is session task and command task?
Separate from an archive server and a powerhouse?
what is the size of your data warehousing?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
How might one distinguish in the case of mapping is right or not without associating session?
can u give example for factless fact table
State the limitations where we cannot use joiner in the mapping pipeline?
what is unit testing?tell me proceedure
COM components can be used in Informatica
what are the Methods For Creating Reusable Transformations?
r u done any partitions in ur project?
What is a joiner transformation?
How big was your fact table
When do you use sql override in a lookup transformation?
Explain how to import oracle sequence into informatica?
