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
- 7864 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
What is the need of etl tools?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Why sorter is an active transformation?
What if the source is a flat-file?
Enlist the advantages of informatica.
Describe an informatica powercenter?
What is data transformation manager process?
What is rank transformation in informatica
How to generate sequence numbers?
Explain pushdown optimization and types in informatica
How do you load first and last records into target table?
What is blocking transformation?
What are the settings that you use to configure the joiner transformation?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Please let me know how to make encryption and decryption with example?
