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
- 7774 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 do you mean by enterprise data warehousing?
Explain what are the different versions of informatica?
What is meant by a domain?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
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.
What is a difference between complete, stop and abort?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Explain the different lookup methods used in informatica?
can you please explain me pre session and post session options?
Target increases every day even though no new record was inserted
What is informatica metadata and where is it stored?
r u done any partitions in ur project?
Briefly explain the aggregator transformation?
How many ways a relational source definition can be updated and what are they?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
