In Flat file
Input is
A
B
C
I need output like this
A
A
A
B
B
B
C
C
C. How will u achieve this?
Answer Posted / ankur saini
to make this simple from sq--take 3 expressions---add union
to take data from theses three expressions
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What are data-driven sessions?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Describe data concatenation?
What is the commit type if you have a transaction control transformation in the mapping?
What are the differences between a connected lookup and unconnected lookup?
What is the advantage of informatica?
What is dynamic cache?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How big was your fact table
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
If informatica has its scheduler why using third party scheduler?
What is enterprise data warehousing?
pmscmd startworkflow -sv
Can we create multiple integration service on single repository?
What is the difference between a repository server and a powerhouse?