Answer / anoymous

In rank t/r select properties tab
select top and number of ranks is 4

Answer / ganesh

write a query like

select * from <table_name> order by where sal=(select max(sal) from <table_name>)

Answer / ,ike

well as per my knowledge
sc-->sq-->rank t/r-->target
In the rank transformation need to check rank port of sal
and group by empno.

correct me if i was wrong

Global and Local shortcuts. Advantages.

0 Answers  

---

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

4 Answers   IBM, Infotech,

---

When to use normalization transformation other than cobol source?

2 Answers  

---

what is bitmap index? did u use it?and how to use it in informatica

1 Answers   IBM,

---

What is exclusive and normal mode for repository services?

0 Answers  

---

Hi 2 every one. i dont have real time experience, and please suggest me for following questions. a) we get the source data from what type of source systems? b) In banking domain project what are the FACT & DIMENTION tables please list out them? c) please write some colomn names in a table? Please reply for aboue questions?..... Thanks in advance.

1 Answers   Amdocs,

---

Differentiate between reusable transformation and mapplet.

0 Answers  

---

Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,

---

What is predefined event?

1 Answers  

---

how can you load data into target table without leading zeor's

4 Answers   Deloitte,

---

A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?

5 Answers   HP,

---

what is the flow?

1 Answers  

---