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
Explain how many types of dimensions are available in informatica?
Can u generate reports in Informatica?
How to start a workflow using pmcmd command?
What is a transaction control transformation?
What are the different types of olap? Give an example?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What are the different components of powercenter?
How an expression transformation differs from aggregator transformation?
How can you validate all mappings in the repository simultaneously?
Enlist the tasks for which source qualifier transformation is used.
Which means the first record should come as last record and last record should come as first record and load into the target file?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Is there any target staging area in informatica not staging area
What is sq transformation?
What are pre and post-session shell commands?