Answer Posted / krishna

hi neetu,
i hope you were a bit wrong.
static cache is also used to check whether row exists or
not.....
well krishna for your question on dynamic cache..
static cache is one in which data when changed in the
target table cannot be incorporated in the look up on the
fly.
when you use a dynamic cache any changes to the target
table gets reflected in the lookup even if the record is
being inserted or updated in the same mapping run priorly

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

960

---

As union transformation gives UNION ALL output, how you will get the UNION output?

1054

---

Explain the tuning lookup transformation - informatica

958

---

where to store informatica rejected data?

1052

---

which one is better performance wise joiner or look up

1037

---

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1899

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2331

---

what is diff b/t sorter t/r and agg have the option sorter property...

2141

---

Sequence generator, when you move from develoment to production how will you reset

1961

---

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

2112

---

Could you explain what is enterprise data warehouse?

1070

---

How to convert multiple rows to single row (multiple columns) in informatica

1331

---

What is rank index in rank transformation?

1016

---

What is the need of etl tools?

1068

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1942

---