let the attribute name be abcabc and name be aaa and table name be 1 i

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

Question Posted / ch naveen kumar

10 Answers
20311 Views
Cap Gemini, IBM, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

draw informatica architecture 8.6 ?

3932

What is standalone command task?

1376

What is the way to execute pl/sql script using informatica mapping?

1681

What are the informatica performance improvement tips

1152

How do you set a varible in incremental aggregation

1945

What is the difference between STOP and ABORT options in Workflow Monitor?

1312

Separate from an archive server and a powerhouse?

1011

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1100

What is meant by pre and post session shell command?

1202

what is Active lock explain

2858

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10729

Explain lookup transformation in informatica

1131

Can we create a node as a gateway node and the same node can be assigned to a grid?

1125

what is the size of u r source(like file or table)?

2310

How many types of sessions are there in informatica.please explain them?

1211