Answer / divi

Alternative to Lookup id Joiner.we need to import source
structure of target in Source Analyser and bring that into
mapping and use it for comparison like Lookup.

Answer / krishna

In the sesion u hav to put update else insert

Answer / shashiall

plz..use "update else insert" in the properties of session.

Answer / saritha

You can use Joiner transformation to design scd Type1
manually. Import target as source and use joiner
transformation. Use expression to insert and update the
rows into target.

Explain direct and indirect flat file loading (source file type) - informatica

0 Answers   Informatica,

---

How to do the error handling of if ur source is flatfiles?

0 Answers  

---

what is service oriented architecture in Informatica 8 version

1 Answers   Cap Gemini, IBM, Systech, TCS,

---

How many ways are there to create ports?

0 Answers   Informatica,

---

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

3 Answers   Syntel,

---

Repository user profiles

0 Answers  

---

What are limitations of joiner transformation?

2 Answers   Exilant, TCS,

---

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000

1 Answers   HP,

---

how to identify new and old values in source qualifier or any other transformations using informatica

2 Answers  

---

What is incremental aggregation and how it is done?

8 Answers   JPMorgan Chase, TCS,

---

What is informatica metadata and where is it stored?

0 Answers  

---

What are the types of maping wizards that r to be provided in Informatica?

2 Answers  

---