write a query following source
region sales
1 1000
2 2000
i want the output ?please give solution
1 2
1000 2000
Answer Posted / lchenchureddy
use Normalized transformation in the mapping.we get result.
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
What are the various types of transformation?
How is union transformation utilized?
Do you find any difficulty while working with flat files as source and target?
Explain the types of transformations?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Is there any target staging area in informatica not staging area
What is the difference between stop and abort in informatica
What is a router transformation?
What are the uses of etl tools?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is Cognos script editor?
What are pre and post-session shell commands?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What are active and passive transformations?
What is informatica? Why do we need it?