Answer / s

We can achieve this

SRC->EXP->UPD->TGT.

In Update Transformation put DD_UPDATE. And in target add
update_override to update the required columns based on the
condition. At session level set the target load attribute
as INSERT, UPDATE ELSE INSERT.

Answer / jay

SQ ---------> UPD --> TRG
| ^
| |
--> LKP --

In update startegy, just give type as formula
iif(isnull(LKP_Col1), 0, 1)

0 --> DD_INSERT
1 -->DD_INSERT

Answer / ppl

using scd type 2 v can do dis

My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?

6 Answers   Accenture,

---

Performance tuning in UNIX for informatica mappings?

0 Answers   CGI, CTC,

---

What are the features of complex mapping?

0 Answers  

---

What is the advantage of persistent cache? When it should be used.

1 Answers   Wipro,

---

What is the use of code page?

0 Answers  

---

What are the types of schemas we have in data warehouse and what are the difference between them?

0 Answers  

---

normalizer transformation

3 Answers   CTS,

---

tell me the push down optimization

2 Answers   Wipro,

---

If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.

3 Answers   IBM, TCS,

---

Can any one describe what is audit table briefly?how does it look like and what are the columns in it?

3 Answers   Syntel,

---

how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)

3 Answers   Cognizant, HP, TCS,

---

Describe two levels in which update strategy transformation sets?

1 Answers  

---