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 is domain in terms of informatica?
what is mean by complex business rule ?
State the differences between sql override and lookup override?
explain about unit testing? in real time?
Enlist the tasks for which source qualifier transformation is used.
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Briefly describe lookup transformation?
How to elaborate tracing level?
What is the difference between a connected look up and unconnected lookup?
What is incremental aggregation?
What are the issues you have faced in your project? How did you overcome those issues?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What can we do to improve the performance of informatica aggregator transformation?
What is the difference between STOP and ABORT options in Workflow Monitor?
What is a dimensional model?