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
- 8304 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
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Explain dynamic target flat file name generation in informatica
Partition, what happens if the specified key range is shorter and longer
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Explain about cumulative Sum or moving sum?
How to update source definition?
What is data transformation manager process?
What the difference is between a database, a data warehouse and a data mart?
What are the different types of transformation available in informatica.
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How to go to the older version for a mapping?
What is an expression transformation in informatica?
In development project what is the process to follow for an etl developer from day1
Define mapping and session?
