Answer / guest

we can not have flat override in any of the Transormation.
We have only sql query here we can use the custom query for
relational sources and we have lookup override is there
here we can sql query for relational sources suppose we
going to lookup on relational table.

I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me

6 Answers   Mastek,

---

What are the types of lookup transformation?

0 Answers   Informatica,

---

what is constraint based loading

2 Answers   IBM,

---

from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic

21 Answers   Deloitte,

---

i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time

3 Answers   iGate,

---

Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...

3 Answers  

---

is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?

3 Answers   IBM,

---

How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?

4 Answers   IBM,

---

Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .

5 Answers  

---

Filter transformation in the condition one of the data is NULL would the record be dropped.

2 Answers  

---

How do you use reject loader.

0 Answers  

---

Define Pmrep command?

0 Answers  

---