Answer / koti

in correlated query is nothing but a sub query, but the difference is sub query can executes first, based on the result the main query executes...

Answer / ramesh

correlated view is a top down approch

Explain the code page compatibility?

0 Answers  

---

what is casual dimension?

6 Answers   IBM,

---

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

0 Answers   CTS,

---

How can we improve session performance in aggregator transformation?

0 Answers   Informatica,

---

how can i invoke pmcmd in command line prompt

1 Answers  

---

---

How to compare Source and Target table, without using dynamic lookup?

4 Answers  

---

I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...

6 Answers   TCS,

---

There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?

1 Answers   Wipro,

---

What do you understand by a term domain?

0 Answers  

---

draw informatica architecture 8.6 ?

0 Answers   Cognizant, TCS,

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

2 Answers   TCS,

---

i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

5 Answers   TCS,

---