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
- 7871 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / subhash
SELECT NO, NAME,
MAX(ADDRESS) AS ADDR1,
MIN(ADDRESS) AS ADDR2
FROM TABLE_NAME
GROUP BY (NO,NAME)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the meaning of up gradation of repository?
explan ur project architecture?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is a joiner transformation?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
In informatics server which files are created during the session rums?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How many number of sessions can one group in batches?
What do you mean by blocking transformation?
what are the deliverables?in your project?
Explain joiner transformation in informatica
Could you explain what is enterprise data warehouse?
How can a transformation be made reusable?
What is different between the data warehouse and data mart?
How to elaborate powercenter integration service?
