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
What is informatica? Why do we need it?
Define filter transformation?
What is the session task and command task?
What differs when we choose the sorted input for aggregator transformation?
How many number of sessions can one group in batches?
In warehouses how many schemas are there?
How can we remove the duplicates from flat file source?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How to create Target definition for flat files?
What is transformation?
Reusable transformation and shortcut differences
How do you change a non-reusable transformation to reusable transformation?
Explain the different lookup methods used in informatica?
What is the difference between informatica 7.0 and 8.0?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY