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
- 8129 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
generate date / time dimension in informatica
How many dimensions are there in informatica?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
How you prepared reports for OLAP?
How can you differentiate between powercenter and power map?
How do we call shell scripts from informatica?
Why sorter is an active transformation?
What are the different types of olap? Give an example?
Explain the types of lookup transformation?
What is blocking transformation?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
How do you load alternate records into different tables through mapping flow?
