you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.

3 Answers  

---

What is grain of fact?

0 Answers  

---

Compare ETL & Manual development?

0 Answers  

---

Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)

2 Answers   Cognizant, IBM,

---

IN Informatica, I have 10 records in my source system. I need to load 2 records to target for each run. how to perform.please let me know. I know by using Mapping variable we can perform but how to load please any one explain.

3 Answers   TCS,

---

if u can't find what you are looking for in lookup table, how do you handle?

1 Answers  

---

flat filevalidation in informatica

0 Answers   Hewitt,

---

how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance

0 Answers  

---

we hava a flat file having more than 1000 records and two targets. i have to write first half of the rows into first targets and next half of rows into second target. how can i do in informetica??

1 Answers  

---

What are the names of the layers in etl?

0 Answers  

---

What are the modules in Power Mart?

0 Answers  

---

Compare etl & elt?

0 Answers  

---