Answer / venubyna1

Lookup is better as compare to join
bcoz joiner does not supports to inequality but look
supports to inequality
and both r does not support OR condition

Can we insert and update a target table without using update strategy transformation?How?

4 Answers   Syntel,

---

draw informatica architecture 8.6 ?

0 Answers   Cognizant, TCS,

---

hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you

5 Answers   Patni,

---

scenario

1 Answers  

---

What is the cumulative sum and moving sum?

0 Answers  

---

hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.

2 Answers   IBM,

---

how can one come to know wether the records loak into the target if we use update strategy

1 Answers   Wipro,

---

I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?

6 Answers   Accenture,

---

What are set operators in Oracle

3 Answers   Deloitte, Wipro,

---

Differentiate between mapping parameter and mapping variable?

1 Answers  

---

How to eliminate duplicates from flat file..what is the procedure

4 Answers  

---

What is the surrogate key?

0 Answers  

---