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
- 9793 Views
- I also Faced
- E-Mail Answers
Answer Posted / ankit kansal
It can be one of the solution
tgt table contains two columns
src->sq->exp1-->>tgt(1) one instance of tgt table.
---------exp2-->>tgt(2) second instance of tgt table.
*after sq forward c1 and c2 to exp1
and c1 and c3 to exp2
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Can you use flat files in Mapplets.
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is the benefit of session partitioning?
What are the performance considerations when working with aggregator transformation?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Explain dynamic target flat file name generation in informatica
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
can you please explain me pre session and post session options?
explain one complex mapping with logic? sales project?
What is aggregator transformation in informatica?
What are the different types of olap? Give an example?
What is workflow? What are the components of workflow manager?
Can anyone tell me the new features in Informatica 9 Version?
