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


my source like dis

10,asd,2000
10,asd,2000
10,asd,2000
20,dsf,3000
20,dsf,3000
20,dsf,3000
like dis and my requirement is first record is inserted into
first target and duplicates of first record is inserted into
second target ...like dis way ...?

how to achieve dis?

Answers were Sorted based on User's Feedback



my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 ..

Answer / chandra

take 2 agg Trs after SQ and drag all the ports to both the
AGG Trs and enable group by for all ports for one AGG and
take one output port in second AGG ..,in that take count(no)
then take filter and write condition as count(no)>1


SQ---->AGG(enable all ports group by)-->Tar1
---->AGG(count(no))-->FIL(count(no)>1)--->Tar2

Is This Answer Correct ?    11 Yes 8 No

my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 ..

Answer / santosh kumar sarangi

1.first sort the data with sorter t/r as ID key column and
create below port in exp transformation
var2= var1
id
var1=id
rec_count=iff(var1=var2,rec_count+1,1)
2.Give all the port to router t/r and give the filer
condition as below
rec_count=1 then to first target
default to 2nd target

Let me know if any things is wrong.

Thanks & Regards
Santosh Kumar Sarangi

Is This Answer Correct ?    1 Yes 0 No

my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 ..

Answer / baswaraj

take a normalizer tr and set port vale 2 r 3 how much u
required and drag remaing ports as it is

Is This Answer Correct ?    0 Yes 1 No

my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 ..

Answer / ramakrishna

SQ---->AGGR(CREATE O/P PORT AS RCOUNT)WRITE EXPRESSION AS
COUNT(EMPNO)SELECT GROUPBY TO EMPNO
---->ROUTER(GRP1- TRUE)--- TRG1
(GRP2-RCOUNT>1)--TRG2

Is This Answer Correct ?    1 Yes 7 No

Post New Answer

More Informatica Interview Questions

Explain the tuning lookup transformation - informatica

0 Answers   Informatica,


Quickly characterize reusable change?

0 Answers  


split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar

1 Answers   Cap Gemini, TCS, Wipro,


Difference between task flow and linear task flow

0 Answers  


How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important

4 Answers   CTS,


Explain the types of transformations?

0 Answers  


While importing the relational source defintion from database,what are the meta data of source U import?

1 Answers  


What is an unconnected transformation?

0 Answers   Informatica,


i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z

1 Answers   HCL,


How can one identify whether mapping is correct or not without connecting session?

0 Answers  


source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?

5 Answers   Wipro,


What is the difference between IN and Exists in Oracle?

4 Answers   Deloitte,


Categories