Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

How do you migrate data from one environment to another?

1095


What does reusable transformation mean?

1132


Clarify the utilization of aggregator cache record?

1000


Suppose we do not group by on any ports of the aggregator what will be the output?

1041


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2056


Enlist the tasks for which source qualifier transformation is used.

1040


How can we handle two sessions in informatica?

1031


What is meant by LDAP users?

1208


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?

1105


What is a router transformation?

1127


What is a rank transform?

1084


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1091


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.

1708


what is degenerated dimension?

3996


How to elaborate tracing level?

1177