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  

---

A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?

0 Answers  

---

What are the different Lookup methods used in Informatica?

0 Answers  

---

what is HISTOGRAM? how to generate statistics?

1 Answers  

---

What are cubes and olap cubes?

0 Answers  

---

how would u estimate the size of Aggregator transform data and index cache?

0 Answers  

---

how many maximum session supports to multiload in teradata ??

0 Answers   IBM,

---

Two default user groups created in the repository are____and_____.

0 Answers  

---

Hi, Urgent recruitment in CTS for informatica ETL .Experience 3 to 10 years.

3 Answers   TCS,

---

how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.

2 Answers   CTS,

---

What is Data Vault???

0 Answers  

---

what are the production issues in datastage?

0 Answers  

---