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 / ch naveen kumar
let the attribute name be abcabc and name be aaa and table
name be 1
insert into 2 abcabc from 1 where count(aaa)<5;
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How do you migrate data from one environment to another?
What does reusable transformation mean?
Clarify the utilization of aggregator cache record?
Suppose we do not group by on any ports of the aggregator what will be the output?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Enlist the tasks for which source qualifier transformation is used.
How can we handle two sessions in informatica?
What is meant by LDAP users?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is a router transformation?
What is a rank transform?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
what is degenerated dimension?
How to elaborate tracing level?