Answer / rahul

In Lookup transformation;
Unconencted is used when ever u want to call the same
transformation several times and u have one return port.

Use dynamic cache if u want to update the case while
updating the target table itself and static is untouched
with the cache.

Answer / sreenu

Unconnected lkp is used for the performance preps bcz hear
we can return only one port and also it is not participated
in mapping directly in ulkp we can use only static cache.

Static cache: static cache is used in unconnected lkp, once
the data is cached it won’t modified.
Dynamic cache: in connected lkp we can use dynamic lkp. By
the use of dynamic lkp we can capture the changed
data.becage dynamic cache is automatically update the
cached data

Answer / satyam

We use an unconnected transformation when we need one
return column from each row and it receives values from:
LKP expression from another transformation.

Answer / tanay

1.We use unconnected transformation to use multiple number
of tables or views without physically taking the entity
into mapping.This kind of transformation is also helpful
when single return port is required.

What is joiner change?

0 Answers  

---

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

0 Answers  

---

In session log thier should not be a single error how will u do

3 Answers   HCL,

---

what is rank and dense rank in informatica with any examples and give sql query for this both ranks

4 Answers  

---

expain about the tune parameters?

0 Answers   TCS,

---

Which gives the more performance when compare to fixed width and delimited file ? and why?

3 Answers   HP,

---

Define maping and sessions?

3 Answers  

---

what is shared Cache. when we will use shared Cache?

4 Answers  

---

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?

2 Answers   Span Systems,

---

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

0 Answers  

---

What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?

2 Answers   IBM, Wipro,

---

i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486

2 Answers   Accenture,

---