Answer / sudhansu

Informatica is an ETL(Extract transformation Load) tool , which loads data into a centered area called Data mart or DW. Business can analyze data using a reporting tool and make decision for improvment of business.

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

0 Answers  

---

If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?

1 Answers   TCS,

---

If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????

2 Answers  

---

if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.

5 Answers   Wipro,

---

there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?

1 Answers   Emphasis,

---

What is a parameter When and where do you them when does the value will be created

0 Answers  

---

guys which is the best institute in banglore to learn informatica??

2 Answers  

---

A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?

5 Answers   HP,

---

What happens if the info. Server doesn't find the session parameter in the parameter file?

1 Answers  

---

What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?

1 Answers  

---

Design a mapping to get year of join for each employee.

4 Answers   Accenture,

---

Enlist the advantages of informatica.

0 Answers  

---