Interested to Buy Any Domain ? << Click Here >> for more details...
In a scenario I have col1, col2, col3, under that 1,x,y, and
2,a,b and I want in this form col1, col2 and 1,x and 1,y and
2,a and 2,b, what is the procedure?
- 5 Answers
- 10040 Views
- I also Faced
- E-Mail Answers
Answer Posted / ram
Create normaliser...
derive 2 ports
col_1 occurence=2
col_2 Occurence=2
now you will get four input ports..
col1 -->col_1
col1---> col_1
col2--->col_2
col3--->col_2
connect two output ports from normaliser to Target..
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
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
What is the format of informatica objects in a repository?
Why filter transformation is an active one?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Tell me about MD5 functions in informatica
can we override a native sql query within informatica? Where do we do it? How do we do it?
Where do we use mapping variables in informatica?
How many ways a relational source definition can be updated and what are they?
How to create or import flat file definition in to the warehouse designer?
Explain the pipeline partition with real time example?
How do you load only null records into target? Explain through mapping flow.
How do you load only null records into target?
complex mapping ur project u r invlve can u explain and give real time example give me ?
How to generate sequence numbers?
Plz can any one say me how to get the informatica certification materials and dumps
