Answer / dharmendra singh

Suppose your look table has f_name,m_name,l_name and you
are using unconnected lookup.In override SQL of lookup use
f_name||~||m_name||~||l_name you cna easily get this value
using unconnected lookup in expression.use substring
function in expression transformation to separate these
three columns and make then individual port for downstream
transformation /Target.

how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)

6 Answers   Accenture,

---

which one is better either active or passive transformation in informatica

1 Answers  

---

Explain pushdown optimization $pushdownconfig parameter - informatica

0 Answers   Informatica,

---

Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance

2 Answers  

---

how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?

4 Answers   CTC,

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

0 Answers  

---

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

0 Answers  

---

What are the options in the target session of update strategy transsformatioin?

2 Answers  

---

What is workflow monitor?

0 Answers  

---

Is it possible to update the target table with PK?

1 Answers   TCS,

---

source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000

6 Answers   CTS, Wipro,

---

What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1

4 Answers   IBM,

---