punyashlok


{ City } banglore
< Country > india
* Profession * etl developer
User No # 57992
Total Questions Posted # 0
Total Answers Posted # 2

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 0
Users Marked my Answers as Wrong # 4
Questions / { punyashlok }
Questions Answers Category Views Company eMail




Answers / { punyashlok }

Question { Cap Gemini, 9096 }

Source table
-------------
ID NAME
--- ------
101 PANKAJ
NULL KUMAR
NULL MATHUR
102 JYOTI
NULL SAXENA
103 SACHIN
NULL TENDULKAR


TARGET TABLE
-------------
ID NAME
--- -------
101 PANKAJ KUMAR MATHUR
102 JYOTI SAXENA
103 SACHIN TENDULKAR


How to do the above scenario in Informatica.


Answer

just take a variable port

then write the condition
decode(id,null,prev_id,id)

prev_id =id(it should be a variable port)

i m just giving an idea

Is This Answer Correct ?    0 Yes 1 No

Question { IBM, 20978 }

how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me


Answer

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

Is This Answer Correct ?    0 Yes 3 No