Answer Posted / sameer

Select * from emplyees
Where sal>(select avg ( sal) from emplyees )
No need to write complex queries

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2131

---

How to improve the performance of a session using sorter transformation?

1146

---

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1995

---

Scheduling properties,whats the default (sequential)

1955

---

Mention some types of transformation?

1048

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1100

---

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2058

---

What are the types of presistent cache in look up tr.

2055

---

How to update source definition?

1087

---

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1920

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

1808

---

Explain the different kinds of facts.

981

---

Is it possible to revert a global repository to local one and why?

1081

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1058

---

What does command task mean?

1148

---