Hi,
I have one scenario.. i want to insert 4 times (Duplicate)
a row in the target. Please help me .
source row: abcabc
Tgt table:
abcabc
abcabc
abcabc
abcabc
Answer Posted / anup shukla
Create router transformation with 4 different ports.
and set condition true for all the four ports.
and take it to the target from union trans.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is dimensional table?
what is the size of your data warehousing?
Slowly changing dimensions, types and where will you use them
what is the hint? how to use it to reduce the query processing in program?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
How do you promote a non-reusable transformation to reusable transformation?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
How to generate sequence numbers without using the sequence generator transformation?
Plz can any one say me how to get the informatica certification materials and dumps
What are the different components of powercenter?
Tell me about MD5 functions in informatica
Clarify the utilization of aggregator cache record?
draw informatica architecture 8.6 ?
What is domain in terms of informatica?
What is workflow? What are the components of workflow manager?