Answer / Shakti Singh Gurjar

ETL (Extract, Transform, Load) is a process used to collect data from various sources, cleanse and transform it as needed, and load it into a destination, such as a database or data warehouse. Here are some examples:
1. Extract: Data is extracted from the source system using SQL queries or other methods.
2. Transform: Data undergoes cleaning, formatting, and validation to ensure its quality and suitability for use in the target system.
3. Load: Data is loaded into the destination system where it can be analyzed, reported on, and used for decision making.nFor instance, an ETL program might extract data from a sales database, transform it by aggregating sales data by region and time period, and load it into a data warehouse for analysis.

I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help

1 Answers   Axtria,

---

i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time

3 Answers   iGate,

---

Briefly describe lookup transformation?

1 Answers  

---

what is the significance of newlookup port in dynamic look up

1 Answers   IBM,

---

Describe an informatica powercenter?

1 Answers  

---

Plz can any one say me how to get the informatica certification materials and dumps

1 Answers   TCS,

---

we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.

2 Answers   Infosys, TCS,

---

Is it possible to have "5 source & 5 Target" in single mapping?

1 Answers  

---

what is the size of your data warehousing?

1 Answers   IBM,

---

How will the document be delivered to me?

1 Answers  

---

whatis the default data driven operation in informatica

2 Answers  

---

How to call stored Procedure from Workflow monitor in Informatica 7.1 version?

1 Answers   Accenture,

---