ename,deptcount
vamshi,3
kumar,5
krish,8
in o/p i want vamshi record 3 times kumar record 5 times
like wise
what is the logic.?
give the entire logic plz
Answer Posted / chandra
ITs simple by using normalizerTr
| Is This Answer Correct ? | 4 Yes | 6 No |
Post New Answer View All Answers
What is the need for an etl tool?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How to start a workflow using pmcmd command?
How many ways are there to create ports?
How can we use mapping variables in informatica?
What is informatica? Why do we need it?
Differentiate between a repository server and a powerhouse?
What are the types of schemas we have in data warehouse.
What is a repository? And how to add it in an informatica client?
What is the advantage of informatica?
What is rank transformation in informatica
How to load a Dimension ? and how to load a fact table?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Define update strategy?
Define pmcmd command?