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?
Answer Posted / nithyanandan
use normaliser transformation for this question
ur source contain 3-column ,
wihile taking to target there is should not be primaty key
colum in ur target table.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What does cheating measurement mean?
Enlist some properties of sessions.
How might you approve all mappings in the archive all the while?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
expain about the tune parameters?
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 to elaborate powercenter integration service?
What's the layout of parameter file (what does a parameter file contain?)?
waht type of interface is used for testing the data in informatica
How to generate sequence numbers using expression transformation?
How do you promote a non-reusable transformation to reusable transformation?
where to store informatica rejected data?
explain one complex mapping with logic? sales project?
How to use procedural logic inside infromatica?
How are indexes created after completing the load process?