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
- 8123 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
Difference between Target-based loading and constraint-based loading?
What are the different options available for update strategy?
Explain your project of banking domian.
What is blocking transformation?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is rank transformation?
What are connected or unconnected transformations?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What do you understand by a term domain?
What is joiner change?
What are the different ways to implement parallel processing in informatica?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What are the settings that you use to configure the joiner transformation?
What is an expression transformation?
How can we create index after completion of load process?
