i have source as
Column1
101 a 101 b 101 c
so i want to load target as
column1 ---> 101 abc

Answer Posted / mahesh

using Aggregator ......

create group by on col1

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between source qualifier and filter transformation?

1268


What is the need for an etl tool?

826


What is aggregate cache in aggregator transformation?

821


What is a passive transformation?

810


Explain the different kinds of facts.

729


What are the differences between joiner transformation and source qualifier transformation?

858


What are mapplets? How is it different from a Reusable Transformation?

834


Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

1842


differences between service based and product based?

1755


Explain the different lookup methods used in informatica?

776


Explain what are the different types of transformation available in informatica.

760


Explain pushdown optimization and types in informatica

833


How many ways are there to create ports?

931


What could be the possible resons of locks by user?

845


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1786