Answer / ajay konidena

we can't say how much we use .
it is depend on the project requirement so
u must have deep knowledge on both sql,plsql of any DB

Answer / chinni

If your'e well versed with Oracle. In performance point of
view use pre-sql and post-sql or sql query in source
qualifier transformation. If your'e having minimal
knowledge on sql or pl/sql then go for Informatica bcz its
a 3rd party tool which will give solutions in less time
than Normal Oracle.

in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?

9 Answers   Target,

---

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  

---

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

0 Answers   HCL,

---

hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you

5 Answers   Patni,

---

How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?

2 Answers   iFlex, TCS,

---

what is the exact meaning of domain?

3 Answers  

---

what is the necessity to use update strategy?(except for updates)

2 Answers   Emphasis,

---

Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.

2 Answers  

---

Explain the difference between a data warehouse and a data mart?

0 Answers  

---

i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .

6 Answers   Emphasis,

---

How can you define user defied event?

0 Answers  

---

What does reusable transformation mean?

0 Answers  

---