use union transformation or you can write sql override if you have advance

How will you combine 3 different sources with a single source?

Question Posted / rkumar.etl

Answer Posted / rkumar.etl

use union transformation or you can write sql override if
you have advance knowledge of table join conditions for the
current database.

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2186

Is there any way to read the ms excel datas directly into informatica?

1067

How to delete duplicate row using informatica?

1086

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1118

What is the difference between STOP and ABORT options in Workflow Monitor?

1306

What is target load order?

1297

While migrating the data from one environment to another environment how would you manage the connections?

1127

what is index?how it can work in informatica

2081

What is union transformation?

1015

What is informatica worklet?

1113

Performance tuning in UNIX for informatica mappings?

2620

Explain in detail about scd type 1 through mapping.

1626

where to store informatica rejected data? How to extract the informatica rejected data?

1053

Differentiate between Load Manager and DTM?

2208

What is an aggregator transformation?

1142