Answer / ashis

Add to sweta's answer:

We use lookup transformation to lookup data from a
relational table, view, synonym or flatfile against another
or the same table, view, synonym or flatfile.

This is mainly(not only)used for SCD's. So that the value
in the source can be compared with the existing target.

Lookup transformation are of different types named and
unnamed.

Mostly used lookup transformation types are Connected lookup
(Persistent Lookup, Dynamic lookup, Cached lookup, Uncached
lookup)

Answer / swetha

Use lookup transformation in u'r mapping to lookup data in a
relational table, view, synonym.

Informatica server queries the look up table based on the
lookup ports in the transformation. It compares the lookup
transformation port values to lookup table column values
based on the look up condition.

how i will stop my workflow after 10 errors

1 Answers   HP,

---

In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?

3 Answers  

---

Issue with Update override at Target table in Informatica.

2 Answers  

---

What is surrogate key?

9 Answers  

---

In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.

2 Answers   Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,

---

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

2 Answers  

---

in performance wise union is past,union all is past

2 Answers  

---

if i am having 10 records in source, i want 20 records in target...how will you do it

13 Answers   BirlaSoft, IBM,

---

hi all when i am creating repository contents i am getting this error and not able to create contents please let me know wht may be the problem ORA-01031: insufficient privileges Database driver error... Function Name : executeDirect SQL Stmt : CREATE VIEW REP_DATABASE_DEFS AS SELECT DISTINCT DBDNAM DATABASE_NAME, SRCNAM DEF_SOURCE, SUBJ_NAME SUBJECT_AREA, NULL VERSION_ID, OPB_DBD.VERSION_NUMBER DATABASE_VERSION_NUMBER FROM OPB_DBD, OPB_SUBJECT, OPB_SRC WHERE OPB_DBD.SUBJ_ID = OPB_SUBJECT.SUBJ_ID AND OPB_SRC.DBDID = OPB_DBD.DBDID AND OPB_SRC.VERSION_NUMBER = OPB_DBD.VERSION_NUMBER AND OPB_SRC.IS_VISIBLE = 1 Oracle Fatal Error Database driver error... Function Name : ExecuteDirect Oracle Fatal Error Error occurred while creating the repository An error has occurred while creating contents. Dropping repository tables... Create Contents operation on repository [reposerv] ended at 01/02/2009 13:02:48. Elapsed time is 0:00:09.

2 Answers  

---

how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

0 Answers   Patni,

---

what is data driven in update strategy transformation?

2 Answers   HCL, PayPal,

---

what are the perameter and variable?

3 Answers   IBM,

---