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
- 9182 Views
- Informatica, I also Faced
- E-Mail Answers
Answer Posted / amedela chandra sekhar
By using aggregator t/r we can achieve.
use || function
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
What are the types of lookup transformation?
write a query to retrieve the latest records from the table sorted by version(scd)
What is exclusive and normal mode for repository services?
Write the program through which the records can be updated?
What is a joiner transformation?
lookup transformation with screenshots
whats the logic to load the lower level of granularity of data to fact table.
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?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
State the differences between sql override and lookup override?
Define mapplet?
Tell me about MD5 functions in informatica
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What are active transformations.
What you know about transaction control transformation?
