Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 4 Answers
- 10317 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / user
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 |
Post New Answer View All Answers
What is a node in Informatica?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How to join three sources using joiner?
complex mapping ur project u r invlve can u explain and give real time example give me ?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What are the different types of transformation available in informatica.
How you can differentiate between connected lookup and unconnected lookup?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is an Integration service in Informatica?
What are the databases that informatica can connect to windows?
What are the differences between source qualifier and joiner transformation?
have u done any performance tuning? how u ll do?
What is workflow? What are the components of workflow manager?
What is the difference between router and filter?
What is the use of code page?
