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 tasks that source qualifier perform?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is decode in informatica?
How are indexes created after completing the load process?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is dynamic cache?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Enlist the advantages of informatica.
Explain scd type 3 through mapping.
What is substr in informatica?
wf dont have integration severances how you can run?
How to extract sap data using informatica?
How do you take back up of repository?
What is union transformation?
What are the basic requirements to join two sources in a source qualifier transformation using default join?