Answer / srinivasulu raju

It is a Process of Defining the User Defined SQL Query: "to
filter the data,Join the Data, Sorting the data,
eliminating Duplicates...

Condition: Source must be DataBase.

Answer / rams

yes

a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100

2 Answers   Cap Gemini,

---

How to do unit testing in informatica? How to load data in informatica ?

0 Answers  

---

How are the sources and targets definitions imported in informatica designer?

0 Answers   Informatica,

---

suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?

2 Answers   emc2,

---

i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.

3 Answers  

---

---

What is source qualifier transformation?

1 Answers  

---

i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

10 Answers   Emirates, IBM,

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  

---

i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....

1 Answers  

---

What is the difference between OLTP and ODS?

4 Answers  

---

Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that

5 Answers   TCS,

---

Explian the connected and unconnected lookup transformation

1 Answers   Informatica,

---