Answer / srinu

I know 4 ways in INFORMATICA

1)Source Analyzer window-
(source table,Using key ports(enable,disable)).
2)Source qualifie Trans-
(Sql override)
3)Target override
4)Pre sql,Post sql

Any corrections,, srinu.srinuvas@gmail.com .

Answer / roshan

one more way is to write stored procedure and use target pre load and target post load option using unconnected stored procedure T/R...
for more detail
infernonag@gmail.com

Answer / rekha

YES

Answer / amarnath

when you import a target into designer you have an option
to drop constraints or create it and some other options as
well. go and edit the target u will fins all the options.
u can drop constraints and index before loading and re-
create it after the load with these options. this is the
simple method provided by informatica.

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse

5 Answers   TCS,

---

Tell me about MD5 functions in informatica

0 Answers  

---

What are the different threads in DTM process?

2 Answers  

---

Can we call a stored procedure from a unix script which is run using command task

1 Answers   TCS,

---

Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario

4 Answers   TCS, Wipro,

---

Differentiate between source qualifier and filter transformation?

0 Answers  

---

What is hash partition?

2 Answers  

---

If you want to create indexes after the load process which transformation you choose?

3 Answers   HCL,

---

Do you have knowledge in ralph kimball methodology

1 Answers  

---

can we send mail when ever it get success or faulure to other mailid?(Not company mail id)

1 Answers   Puma,

---

Target increases every day even though no new record was inserted

0 Answers   Accenture,

---

What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.

3 Answers   Amdocs, Deloitte,

---