Answer / Vandana Barya

The complex transformation used in Informatica depends on the specific data integration scenario and the source and target systems. Common transformations include data cleansing, data mapping, data blending, data masking, and data enrichment.

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

4 Answers   Virtusa,

---

source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks

4 Answers   Polaris,

---

Why use the lookup transformation ?

2 Answers   Informatica,

---

What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?

5 Answers   TCS,

---

What is the sql query overwrite in source qualifier in informatica

1 Answers   Informatica,

---

How do you Merge multiple Flat files for example 100 flat files with out using Union T/F

4 Answers   IBM,

---

what is mean by complex business rule ?

1 Answers   Cap Gemini,

---

How union transformation is active ?

2 Answers   Puma,

---

why we use datawarehouse

0 Answers   HCL,

---

PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U

2 Answers  

---

Briefly describe lookup transformation?

1 Answers  

---

To provide support for Mainframes source data,which files r used as a COBOL files

1 Answers  

---