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
- 8037 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 are the issues you have faced in your project? How did you overcome those issues?
What is rank index in rank transformation?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What are the new features of informatica 9.x at the developer level?
waht type of interface is used for testing the data in informatica
where to store informatica rejected data?
What are batches?
what is size of u r database?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
How you prepared reports for OLAP?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is event and what are the tasks related to it?
What are session parameters ? How do you set them?
How to load the data from a flat file into the target where the source flat file name changes daily?
Could you explain what is enterprise data warehouse?
