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
- 10 Answers
- 17635 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answer Posted / kamleshmishra291
After sQ use a java transformation with this logic
for (int i=0;i<4;i++)
{
o_col= (input col that have the value);
generateRow();
}
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
write a query to retrieve the latest records from the table sorted by version(scd)
What do you mean by enterprise data warehousing?
How can we improve session performance in aggregator transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
How can you increase the performance in joiner transformation?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is the function of aggregator transformation?
can u give example for factless fact table
Enlist the tasks for which source qualifier transformation is used.
What does command task mean?
How can we use batches?
What is the use of transformation?
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.
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
