Answer / niharika panda

Informatica is an ETL tool used in DWH concept.
It keeps historical data. So all those organizations who wants
to keep their all data i.e. updated and historical too(not
only to update data and deleting the old data) can use it.

Answer / jagadeesh gaddam

Informatica is an etl toll .it loads the data from various oltps like homogenius as well as hetrogeniuse.based on this loadig  data we can genarate the reports what we exactly want for our business development and anyalise the business and take the right decissions 

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

2 Answers   Zensar,

---

i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z

1 Answers   HCL,

---

in my source table i want to delete first and last records and load in between records into target? how can it possible?

3 Answers   HCL, Thomson Reuters,

---

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.

0 Answers  

---

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

0 Answers   IBM,

---

---

How informatica recognizes mapping?

2 Answers   CTS,

---

what is the location of parameter file in informatica?

1 Answers   TCS,

---

version controlling in informatica?

3 Answers  

---

I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me

6 Answers   Mastek,

---

If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?

1 Answers  

---

what are the challenge face in u r project?explain me

1 Answers   iGate, TCS,

---

how to create user defined function (udf) in informatica

0 Answers   Informatica,

---