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 / 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
What is an expression transformation in informatica?
What are the settings that you use to configure the joiner transformation?
Clarify the utilization of aggregator cache record?
How you can differentiate between connected lookup and unconnected lookup?
What is an unconnected transformation?
What is joiner change?
What is the way to execute pl/sql script using informatica mapping?
How to do unit testing in informatica?
Explain the mapping variable usage example in informatica
How can you validate all mappings in the repository simultaneously?
Different circumstance which drives informatica server to expel records?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Enlist few areas or real-time situations where informatica is required.
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance