Answer / suraj kedia

Look up t/r is used in a mapping to look up data in a
relational table,flat file,view or synonym.

The informatica server queries the look up source based on
the look up ports in the transformation.It compares look up
t/r port values to look up source column values based on the
look up condition.
Look up t/r is used to perform the below mentioned tasks:

1) To get a related value.
2) To perform a calculation.
3) To update SCD tables.

Enlist the differences between database and data warehouse.

0 Answers  

---

In a sequential batch can you run the session if previous session fails?

4 Answers  

---

how to declare array in plsql?

1 Answers  

---

what is DSS?

3 Answers  

---

What is rank index in rank transformation?

0 Answers  

---

To import the flat file definition into the designer where should the flat file be placed?

0 Answers   Informatica,

---

Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

1 Answers   IBM,

---

Why is sorter an active transformation?

0 Answers  

---

need for registering a repository server

1 Answers  

---

Explain the different kinds of facts.

0 Answers  

---

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 .

0 Answers   Amazon,

---

What are the mapping paramaters and mapping variables?

1 Answers  

---