Source as
1
1
2
2
3
3
How to get target as 1 2 3
and
1
2
3

Answer Posted / arjun

hi,
take aggrtr in that take one var , count the var group by i/p these go to one tgt and take another same tgt for that, take aggrtr ports i.e, i/p and var ports to filter in that give cndtion not isnull(var) and take i/p port to secnd tgt.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different types of repositories created using informatica?

654


What is a surrogate key?

558


What is an unconnected transformation?

660


Scheduling properties,whats the default (sequential)

1461


Can we change Dynamic to Static or Persistent cache? If so what happens?

1725






What are ETL Tools?

664


permutations of mapplet

2038


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

1965


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

622


Plz can any one say me how to get the informatica certification materials and dumps

1595


Different qualification between a related rotate toward the sky and isolates look upward?

550


Enlist the differences between database and data warehouse.

545


One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

1748


How might you approve all mappings in the archive all the while?

601


Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

1740