Answer / swetha

An unconnected transforamtion is not connected to other
transformations in the mapping.

Connected transforamation is connected to other
transforamtions in the mapping.

Answer / rekha

CONNECTED : IT INVOVLES IN THE MAPPING DATA FLOW
IT RECIVES MULTIPLE INPUTS AND PROVIDES MULTIPLE OUTPUTS
UNCONNECTED :
IT DOES NOT INVOLVE IN THE MAPPING DATAFLOE
RECEIVES MULTIPLE INPUTS AND PROVIDES SINGLE OUTPUT

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

0 Answers   TCS,

---

Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3

3 Answers   CTS,

---

for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.

11 Answers   Accenture,

---

Define joiner transformation?

0 Answers  

---

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 is resilience time?

0 Answers  

---

What is souce qualifier transformation it is active or passive

2 Answers   HCL,

---

What is different between the data warehouse and data mart?

0 Answers  

---

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

4 Answers   CTC,

---

Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?

4 Answers  

---

Where can we find the throughput option in informatica?

0 Answers  

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

0 Answers  

---