Answer / sandipana

select rownum as rank,emp_id,sal from(select
lastname,salary from employees orderby salary desc)
where rownum IN(1,3,5);

Answer / priyank

select * from (select rownum rn,emp.* from emp) where mod
(rn,2)=1;

Answer / millar

ie.

select column from table_name where mod(primary_key_column,2)=1;


select employee_id from employees where mod(employee_id,2)=1

Answer / jhansi

It displays odd rows
select * from emp where (rowid,0) in(select rowid,mod
(rownum,2) from emp);

Answer / punyaslok

(select * from emp)-(select rownum,emp.* from emp order by
mod(rownum,2);

Answer / udaya

SELECT * FROM TABLE_NAME WHERE ROWNUM=1 AND ROWNUM=3 AND
ROENUM=5

where does the default group roew in a router is stored what is the default size of memory in router

1 Answers  

in static and dynamic which one is better

2 Answers  

There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping

3 Answers   Wipro,

Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks

2 Answers   IBM,

What is the Hierarchy of DWH?

1 Answers  

can session assigned multiple mappings or not?

2 Answers   Zensar,

How to generate or load values in to the target table based on a column value using informatica etl tool.

0 Answers   Informatica,

source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009

1 Answers   IBM,

if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,

Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.

2 Answers  

Can you generate reports in Informatcia?

1 Answers  

I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?

1 Answers   Franklin Templeton,