Answer Posted / kondeti srinivas

IF IT IS SOURCE FLAT FILE THEN SQL OVER RIDE WILL NOT WORK

IF IT IS FLAT FILE USE UNION TRANSFORMER AND
CONNECT 3 SAME SOURCE STRUCTURES OF FLAT FILES TO UNION T/F AND CONNECT TO TARGET. IT WILL GIVE THE REQUIRED OUTPUT

what is the Default Source Option For Update Strategy Transformation?

1220

---

What are the issues you have faced in your project? How did you overcome those issues?

2346

---

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

2091

---

Which is the t/r that builts only single cache memory?

1176

---

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

2228

---

What are the types of data warehouses?

1498

---

What is powercenter on grid?

1165

---

How union transformation is used?

991

---

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2265

---

Tell me about Propagate functions in informatica

911

---

How do you load unique records into one target table and duplicate records into a different target table?

1205

---

How does a rank transform differ from aggregator transform functions max and min?

1192

---

Explain the aggregator transformation?

1133

---

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

2189

---

What is the use of an aggregator cache file?

1180

---