Answer Posted / sanjay

well if u hav all related sources then u can probably go
for joiner but make sure that use less no. of joiner as it
may decrease your performance.
if u hav sources with same structure and data types then u
can probably go for set operation and matchin it with your
target.
the third one is u hav to do a lot of transformation based
on some analysis and might be u can create differnet
aliases for your target and you can apply your
transformation.


plz let me know if any clarification . your comment will be
appreciatable. :)

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

6965

---

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1036

---

tell me about your project functionality

2318

---

lookup transformation with screenshots

3967

---

What are the databases that informatica can connect to windows?

1021

---

Tell me about Propagate functions in informatica

897

---

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1973

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1242

---

How to use pmcmd utility command?

990

---

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1991

---

How to convert multiple rows to single row (multiple columns) in informatica

1340

---

Can we change Dynamic to Static or Persistent cache? If so what happens?

2164

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2206

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1742

---

I have a flat file, want to reverse the contents of the flat file

1085

---