Answer / chandrababu.sarupuru

Union Transformation allows the Hetrogeneous sources .

So you can join the sources which are having same metadata.

Answer / ananta mishra

yes

Answer / ananta mishra

yes

Please let me know how to make Data masking in informatica..

0 Answers  

---

What is data merging, data cleansing and sampling?

6 Answers   Satyam,

---

How to recover the standalone session?

2 Answers  

---

What is DR strategy for Informatica project?

0 Answers  

---

what is meant by data driven.. in which scenario we use that..?

2 Answers   IBM,

---

what is curr val use for in sequence generator?

2 Answers   Emphasis,

---

1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.

5 Answers   FCS, IBM, Satyam, TCS,

---

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

0 Answers   IBM,

---

my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4

2 Answers   Zensar,

---

What are the rank caches?

2 Answers   Informatica,

---

What you know about transaction control transformation?

0 Answers  

---

How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks

2 Answers   Puma,

---