Interested to Buy Any Domain ? << Click Here >> for more details...
following source
name gender
ramya female
ram male
deesha female
david male
kumar male
i want the target
male female
ram ramya
david deesha
kumar
any body give solution above question?
- 8 Answers
- 12317 Views
- BRAD, TCS, I also Faced
- E-Mail Answers
Answer Posted / voma
use router transformation, In that 2 groups
1 is male, 2 is female,
target is single, but we drag the table twice
In that router 1st group condition
select * from table where gender='male'
2nd group condition
select * from table where gender='female'
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is a mapplet/worklet in informatica?
can we override a native sql query within informatica? Where do we do it? How do we do it?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
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
How can we update a record in the target table without using update strategy?
What do you mean incremental aggregation?
What is a sorter transformation?
What are the various types of transformation?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
difference between informatica 8.1.1 and 8.6
How to join three sources using joiner? Explain though mapping flow.
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Explain the types of transformations?
where to store informatica rejected data? How to extract the informatica rejected data?
