we have 1 source table containing 100 records. now we have to transfer first set of 1-10 (i.e1-10) records to one target table and another set of 1-10(11-20) records to other target table and continue like that till 100th record

3 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,

---

What is tracing level? How many types of transformations supported by sorted input?

0 Answers  

---

what are the facilities provided by data warehouse to analytical users?

0 Answers  

---

I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?

2 Answers   Accenture, Saama Tech, TCS,

---

---

How to increase performance without changing anything in mapping.( In prod)

0 Answers   IBM, Saama Tech, Wipro,

---

Explain the use lookup tables and Aggregate tables?

0 Answers  

---

What are the key benefits of ETL Testing?

0 Answers  

---

Can u access a repository created in previous version of Informatica?

1 Answers   DELL,

---

Give the benefits of data integration suite?

0 Answers  

---

how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)

0 Answers   Thomson,

---

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  

---