Answer / ratalarayudu

hi,

The main purpose of unconnected lookup t/r is

1.To update slowly changing dimensions
2.if we want to use the same lookup multiple times in a
mapping we can go for unconnected lookup
3.if we want to lookup on only selected rows then we can go
for unconnected look up.

regards,
rayudu.

Answer / praveenabhaskar

We can use unconnected lookup transformation when we have
multiple inputs and single output.

create a mapping to retrieve the employees who are getting salary greater than average salary?

4 Answers   TCS,

---

what we require for D.modelling?

1 Answers  

---

How you count the number of records available at your source?

3 Answers   Zensar,

---

i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .

6 Answers   Emphasis,

---

explan ur project architecture?

0 Answers   TCS,

---

---

Describe data concatenation?

0 Answers  

---

Scenario:-  Below is the requirement. Source:-  NAME          ID                    Requirement  RAVI            1                      (no need to repeat as it ID is 1) KUMAR        3                     (repeat 3 times as it ID is 3) John             4                     (repeat 4 times as it ID is 4) Required Out Put:- Name                   ID RAVI                     1                    KUMAR                3      KUMAR                3 KUMAR                3  John                     4 John                     4 John                     4 John                     4 Scenario 2:- Source Data  ID              NAME 1,2            NETEZZA,ORACLE 3,4,5         SQL Server, DB2, Teradata Required Output:-  ID                   NAME 1                  NETEZZA 1                  ORACLE 3                  SQL Server 3                  DB2 3                  Teradata

1 Answers   Cognizant,

---

How do you create single lookup transformation using multiple tables?

6 Answers   TCS,

---

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

0 Answers   Cap Gemini, Cognizant,

---

What are the new features of the server manager in the informatica 5.0?

1 Answers  

---

why union is active transformation?

4 Answers   IBM,

---

If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???

5 Answers   Wipro,

---