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 )

Answer / amedela chandra sekhar

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

Answer / chandra

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

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

I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help

1 Answers   Axtria,

---

How does the server recognize the source and target databases. Elaborate on this.

1 Answers  

---

What is the reusable transformation?

0 Answers  

---

Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.

1 Answers  

---

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,

---

Can anyone tell me the new features in Informatica 9 Version?

0 Answers   Syntel,

---

hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks...

0 Answers  

---

what is degenerated dimension table with scenario

2 Answers   HCL,

---

How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?

2 Answers  

---

i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task

14 Answers   Altisource, TCS,

---

I want expect first and last record remaining all records will be loaded into target? which transformations we can use?

6 Answers   Cap Gemini, CTS,

---

What is the Difference between PowerPlay transformer and power play reports?

1 Answers  

---