Interested to Buy Any Domain ? << Click Here >> for more details...
I HAVE A SOURCE FILE CONTAINING
1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B
AND IN TARGET I SHOULD GET LIKE
1|A+B+C+D
2|A+B
3|A+B
WHICH TRANSFORMATION I SHOULD USE
- 5 Answers
- 8996 Views
- Informatica, I also Faced
- E-Mail Answers
Answer Posted / guest
Aggregator with group by on column with values 1, 2, 3
| Is This Answer Correct ? | 7 Yes | 12 No |
Post New Answer View All Answers
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is the procedure for creating independent data marts from informatica 7.1?
What is source qualifier transformation in informatica?
What is decode in informatica?
What are the different ways to implement parallel processing in informatica?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
How can you generate reports in informatica?
Explain what transformation and how many are there in informatica?
What is mapplet in informatica?
Enlist the differences between database and data warehouse.
What is data caches/ index caches?
Is it possible to revert a global repository to local one and why?
update strategy transformation in informatica
What differs when we choose the sorted input for aggregator transformation?
