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


Please Help Members By Posting Answers For Below Questions

What are some examples of informatica etl programs?

533


Can you generate sequence numbers without using the sequence generator transformation?

597


how to load rows into fact table in data warehouse

637


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

550


difference between repository database and repository service?

618






How to load the name of the current processing flat file along with the data into the target using informatica mapping?

694


TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1462


Why update strategy and union transformations are active?

592


COM components can be used in Informatica

1873


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1866


Describe the impact of several join conditions and join order in a joiner transformation?

645


As union transformation gives UNION ALL output, how you will get the UNION output?

639


Explain direct and indirect flat file loading (source file type) - informatica

826


How to update a particular record in target with out running whole workflow?

1155


What are multi-group transformations?

564