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
- 8119 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 would you copy the content of one repository to another repository?
Differences between connected and unconnected lookup?
What is Data Caches size?
What is the way to execute pl/sql script using informatica mapping?
What are the advantages of using informatica as an etl tool over teradata?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Explain transaction control transformation in informatica
What do you mean by blocking transformation?
Explain constraint based loading in informatica
What are multi-group transformations?
What is source qualifier transformation in informatica?
list out all the transformations which use cache?
What is dimensional table?
What are the new features of informatica 9.x in developer level?
Is it possible to define a single node as a Gateway node as well as worker node?
