just take a variable port then write the condition decode(id,null,prev

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.

Question Posted / user

4 Answers
10510 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

Please Help Members By Posting Answers For Below Questions

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2012

What is domain and gateway node?

1165

What is dynamic cache?

1036

explain about unit testing? in real time?

2205

lookup transformation with screenshots

4006

How you prepared reports for OLAP?

1597

Enlist the advantages of informatica.

1068

How many numbers of sessions can one group in batches?

1064

Slowly changing dimensions, types and where will you use them

1714

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2066

What is the commit type if you have a transaction control transformation in the mapping?

1030

Difference between Target-based loading and constraint-based loading?

1003

What are pre and post-session shell commands?

1311

What is lookup transformation?

1042

What is informatica?

1155