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
20023 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

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1113

What is the meaning of up gradation of repository?

1994

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1796

What is the use of target designer?

1056

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1081

How can you differentiate between powercenter and power map?

1092

can you please explain me pre session and post session options?

7573

Explain target update override in informatica

1126

What is rank transformation?

991

What are the types of schemas we have in data warehouse and what are the difference between them?

943

What are the new features of Power Center 5.0?

1780

Which is the t/r that builts only single cache memory?

1190

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1206

State the differences between sql override and lookup override?

1210

what is the Default Source Option For Update Strategy Transformation?

1241