1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

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

Did u used latest transformations of 8.6.0? for what?

1469

How do you remove duplicate records in informatica? And how many ways are there to do it?

699

How do you load first and last records into target table?

655

How can we handle two sessions in informatica?

606

what are the Methods For Creating Reusable Transformations?

642




To import the flat file definition into the designer where should the flat file be placed?

669

What is an aggregator transformation?

610

Explain sessions. Explain how batches are used to combine executions?

585

What is resilience time?

649

What is meant by LDAP users?

684

Differentiate between a repository server and a powerhouse?

567

What are mapplets?

810

Please let me know how to make Data masking in informatica..

1258

Can we create two repositories on same database instance in oracle?

603

Where are the source flat files kept before running the session?

615