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
Explain the etl program with few examples.
How to update source definition?
What are roles and groups and benefits of using them?
What is flashback table ? Advance thanks
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Explain the use of aggregator cache file?
In development project what is the process to follow for an etl developer from day1
what is the hint? how to use it to reduce the query processing in program?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Differentiate between reusable transformation and mapplet.
How to handle decimal places while importing a flatfile into informatica?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What are the new features of informatica 9.x in developer level?
Differences between connected and unconnected lookup?
How we can create indexes after completing the load process?