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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

how to load duplicate row in a target

Question Posted / giri

Answers were Sorted based on User's Feedback



how to load duplicate row in a target..

Answer / nagaraju bhatraju

take a lookup on t1 and look for dupliates in exp and
collect duplicate values to t2


or


you can hold preveious key value in variable port and can
compare it with new coming value , and you can flag these
rec as duplicate rec if both are matched , i mean previous
and current key, sorter should be used before exp as key
values should be come in sorted order only

(This technique is called forward referencing )

( Note : in other senarios if require you can use self
reference also basing on our requirements )

Is This Answer Correct ?    2 Yes 1 No

how to load duplicate row in a target..

Answer / amedela chandra sekhar

with out p.key in the target table we can load.

Is This Answer Correct ?    1 Yes 0 No

how to load duplicate row in a target..

Answer / chandra

in the source u overide the source qualifier and trough
filter u can overwriter it

Is This Answer Correct ?    0 Yes 1 No

how to load duplicate row in a target..

Answer / swap

You can write UNION ALL query in source qualifier

eg:-select NAME,EMP_ID from EMPLOYEE
UNION ALL
SELECT NAME,EMP_ID FROM EMPLOYEE

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Informatica Interview Questions

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

0 Answers   Saama Tech,

What is an aggregator transformation? it is active why cant it be passive explain?

3 Answers   HCL,

What are the static cache and dynamic cache in informatica?

0 Answers  

S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?

5 Answers   TCS,

what is the size ur source like(file system or database)? how many record daily come u r banking project?

0 Answers   Cognizant, Flextronics,

What is galaxy shema

2 Answers   CGI,

Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?

18 Answers   L&T,

How many ways are there to create ports?

0 Answers   Informatica,

What is the reusable transformation?

0 Answers  

What is the Difference between DSS & OLTP?

5 Answers  

Explain the different kinds of facts.

0 Answers  

How many cubes create from a single model?

1 Answers  

For more Informatica Interview Questions Click Here
Categories