Source as
1
1
2
2
3
3
How to get target as 1 2 3
and
1
2
3
Answer Posted / anu
Select distinct in sorter t/r
then run session twice
but don't enable truncate option in session target properties
I think so
any corrections tell me
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the informatica performance improvement tips
what is degenerated dimension?
What are the differences between oltp and olap?
How to update or delete the rows in a target, which do not have key fields?
What do you mean by worklet?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is enterprise data warehousing?
What are the types of schemas we have in data warehouse.
How would you copy the content of one repository to another repository?
What is informatica?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Enlist the tasks for which source qualifier transformation is used.
How to Create a folder using pmrep command?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is a passive transformation?