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 / jay
Just have four instance of target and
connect source to all 4 target instance.
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
How big was your fact table
difference between repository database and repository service?
what is degenerated dimension?
Explain the code page compatibility?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is fact table? Explain the different kinds of facts.
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What are the reusable transformations?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is update strategy transform?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is the benefit of session partitioning?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?