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
- 10038 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
What's the layout of parameter file (what does a parameter file contain?)?
How do you convert single row from source into three rows into target?
Explain what is informatica metadata and where is it stored?
What is the format of informatica objects in a repository?
What can we do to improve the performance of informatica aggregator transformation?
lookup transformation with screenshots
Explain the scenario which compels informatica server to reject files?
Did u used latest transformations of 8.6.0? for what?
What is a predefined event?
Define Pmrep command?
Why do we need informatica?
What is flashback table ? Advance thanks
What are data-driven sessions?
How do you load unique records into one target table and duplicate records into a different target table?
wf dont have integration severances how you can run?
