you can use source qualifier transformation to do this. write join conditi

without dynamic lookup transformation how to insert new
rows and update existing rows?

Question Posted / vali

Answer Posted / vali

you can use source qualifier transformation to do this.
write join condition ...
the rest of the operation will be same

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are active and passive transformations?

1081

Target increases every day even though no new record was inserted

1580

What is a predefined event?

1093

What is a repository? And how to add it in an informatica client?

1149

Explain in detail about scd type 1 through mapping.

1552

What are the various types of transformation?

1179

Explain incremental aggregation in informatica

1127

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1708

Scheduling properties,whats the default (sequential)

1955

what are the deliverables?in your project?

2152

How many ways a relational source definition can be updated and what are they?

1017

How can we use mapping variables in informatica? Where do we use them?

1200

Explain the etl program with few examples.

1048

 Informatica Checkpoints

3329

How can we remove the duplicates from flat file source?

1038