Answer / mamatha g

POWER CENTER DOESNT HAVE ANY LIMIT ON THE VERSIONS

what r the transformations that r not involved in mapplet?

8 Answers   Wipro,

---

write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null

1 Answers   TCS,

---

I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?

6 Answers   TCS,

---

if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not

2 Answers   Cap Gemini,

---

Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?

2 Answers  

---

---

waht type of interface is used for testing the data in informatica

0 Answers   CTS, TCS,

---

In which scenario did u used Mapping variable?

1 Answers   Cognizant,

---

Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio

4 Answers   IBM,

---

How do you update the records with or without using update strategy?

0 Answers  

---

scenario where i can use only concurrent execution of workflow.

0 Answers   Cognizant,

---

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

0 Answers  

---

What is Code Page Compatibility?

1 Answers  

---