Answer / mike

well informatica is the tool used for data aquisition
process..which is nothing but data extraction, data
transformation and data loading. Inorder to build a data
ware house we use informatica
or
It is a GUI tool and we need informatica for
running,designing,monitoring and administrating the data
flow from various external source and internal sources to
the data ware house

correct me if i was wrong

Answer / deepthi

etl's r of 2 types.code based n gui based.in code based etl
we have some limitations.inorder 2 over come those
limitations we use gui based etl ninformatica is 1 among
the gui.

What are Target Options on the Servers?

1 Answers  

---

For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL

1 Answers  

---

What is meant by lookup transformation? Explain the types of lookup transformation?

0 Answers  

---

we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?

2 Answers  

---

sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it

1 Answers  

---

what is mean by grouping of condition column in lookup transformation?

1 Answers  

---

Target is zero file and how can you send the email?

2 Answers   Bank Of America,

---

write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000

8 Answers   TCS,

---

how the server recognises , if the session fails after loading the 100 records in to the target

2 Answers   TCS,

---

What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

3 Answers  

---

can we create index and drop index in exsisting table while using infomatica

4 Answers  

---

Design a mapping to load a target table with the following values from the above source?

0 Answers   Informatica,

---