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

Why use shortcuts(Instead of making copies).

1 Answers  

Explain what are the different types of transformation available in informatica.

0 Answers  

why we are using level option in normalizer transformation

1 Answers   TCS, Wells Fargo,

What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.

2 Answers   Mphasis,

In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query

8 Answers   Cap Gemini,

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

0 Answers   CTS,

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

0 Answers   TCS,

When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?

5 Answers  

What are the data movement modes in informatica?

0 Answers   Informatica,

How many input parameters can exist in an unconnected lookup?

0 Answers  

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

0 Answers   IBM,

All active transformations r passive or not?

7 Answers  

For more Informatica Interview Questions Click Here
Categories