Answer / rag

Hi You can do this another way also
put the expresession transforamtion and read some previous
record with the currect record or any unique column value in
the expression and if they are equal then assign the
flag(means duplicate flag) else
assign the new flage.
pass the duplicate flag records to the filter and goes to
the TB(duplicate records target) and unique values to the
origonal target

Answer / saradhi

As of my knowledge i think its possible by Router
Transformation.By writing one condition we can extract the
data with out duplication in one target then automatically
default records means with duplication are transferred in
to another target.

Can we override a native sql query within informatica?

0 Answers  

---

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,

---

Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?

3 Answers  

---

Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.

3 Answers   IBM,

---

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

0 Answers   IBM,

---

What are the different caches used in informatica?

3 Answers   UST,

---

What is souce qualifier transformation it is active or passive

2 Answers   HCL,

---

where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers  

---

Explain sessions. Explain how batches are used to combine executions?

0 Answers  

---

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

0 Answers   TCS,

---

What is data transformation manager process?

0 Answers  

---

Parameter and variable differences

0 Answers  

---