Interested to Buy Any Domain ? << Click Here >> for more details...
Hi,
In source I have records like this
No name address
10 manoj mum
10 manoj dilhi
20 kumar usa
20 kumar Tokyo
I want records in target like shown below
No name addr1 addr2
10 manoj mum dilhi
20 kumar usa Tokyo
If it is reverse we can do this by using Normalizer
transformation by setting occurance as 2.
Somebody will say use denoralization technique. But as of my
knowledge I couldn’t find any denormalization technique. Is
there any concept like that?
I tryid this seriously but I could find any idea to
implement this.
Can any one please help me ?
Advance Thanks
- 6 Answers
- 8050 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / santosh
select no, name, max(decode(ronum,1,address1)) as address1,
max(decode(ronum,2,address1)) as address2 from (select
no,name,address1,row_number() over(partition by no order by
no) as ronum from model16) group by no, name
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
In informatica workflow manager, how many repositories can be created?
How do you migrate data from one environment to another?
What are the components of workflow manager?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What does “tail –f” command do and what is its use as an Informatica admin.
How to load the data from a flat file into the target where the source flat file name changes daily?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is the cumulative sum and moving sum?
What is the maplet?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What are the differences between a connected lookup and unconnected lookup?
What is the different lookup cache(s)?
Where can we find the throughput option in informatica?
What is dimensional table? Explain the different dimensions.
