You can write UNION ALL query in source qualifier eg:-select NAME,EMP

how to load duplicate row in a target

Question Posted / swap

Answer Posted / swap

You can write UNION ALL query in source qualifier

eg:-select NAME,EMP_ID from EMPLOYEE
UNION ALL
SELECT NAME,EMP_ID FROM EMPLOYEE

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to do unit testing in informatica? How to load data in informatica ?

1050

Design a mapping to load the cumulative sum of salaries of employees into target table?

1424

what is diff b/t sorter t/r and agg have the option sorter property...

2133

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

957

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1866

How can repository reports be accessed without sql or other transformations?

1161

Why update strategy and union transformations are active? Explain with examples.

1176

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

1101

What are the tasks that source qualifier perform?

1032

How do we call shell scripts from informatica?

1014

Explain informatica architecture - version 8 / 9

1024

Enterprise data warehouse your projects phase by phase explain?

1856

How to extract sap data using informatica? What is abap? What are idocs?

1092

how to load dimension table and fact table. plz tell me the steps.

2039

What is decode in informatica?

1074