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 / jyothi
source s1 contains input data (A B C)
take 3 flows in mapping
create 3 instances for the target.
ex: target is T .Instances for T are t1 t2 t3
t1
/
/
s1---exp---t2
\
\
t3
load the data into targets using target load strategy
then we will get output as above
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What are the new features of Power Center 5.0?
What is rank transformation in informatica
What does command task mean?
Differentiate between source qualifier and filter transformation?
Separate from a database, an information bazaar, and an information stockroom?
Suppose we do not group by on any ports of the aggregator what will be the output?
What is a transaction control transformation?
Under what condition selecting sorted input in aggregator may fail the session?
How we can use union transformation?
What is a filter transformation?
What are data-driven sessions?
Why update strategy and union transformations are active?
State the limitations where we cannot use joiner in the mapping pipeline?
How you can differentiate between connected lookup and unconnected lookup?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?