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
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Explain why we use partitioning the session in informatica?
How can one identify whether mapping is correct or not without connecting session?
Differentiate between Load Manager and DTM?
What are batches?
How can we store previous session logs?
What is event and what are the tasks related to it?
Explain scd type 3 through mapping.
Is it possible to define a single node as a Gateway node as well as worker node?
Mention a few design and development best practices for informatica?
What is substr in informatica?
Mention some types of transformation?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is data transformation manager process?