Answer / amedela chandra sekhar

When we want to get single return port and also we can call
this any where in the mapping.

Answer / davan

if we take one look t/r, look up multiple times in one
mapping at that time we can go for un connected t/r

What are the types of groups in Router transformation?

1 Answers   Informatica,

---

Can u generate reports in Informatica?

0 Answers   Informatica,

---

What are variable ports and list two situations when they can be used?

1 Answers  

---

How/where can i install Informatica software with oracle or teradata as database

0 Answers  

---

hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help

1 Answers  

---

---

which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..

7 Answers   TCS,

---

why we use stored procedure transformation?

4 Answers   IBM,

---

Which one is better performance wise connected/un-connected lkp?why?

2 Answers   HCL, TCS,

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

0 Answers  

---

i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four

3 Answers  

---

how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy

2 Answers   TCS,

---

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

4 Answers  

---