How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,

---

How you count the number of records available at your source?

3 Answers   Zensar,

---

Can anyone please distinguish what is Inner join and Outer join

2 Answers   Wipro,

---

can every transfomation reusable?how?

2 Answers   Wipro,

---

how to through logic of informatica using the push down optimization into oracle.

2 Answers   Hexaware,

---

What are the Differences between static cache and dynamic cache?

1 Answers  

---

Explain about cumulative Sum or moving sum?

0 Answers   Informatica,

---

How to load duplicate records in to a target table which has a primary key?

2 Answers  

---

wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15

3 Answers   Bank Of America,

---

i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?

2 Answers   IBM, Polaris,

---

Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer

0 Answers  

---

Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .

5 Answers  

---