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


Please Help Members By Posting Answers For Below Questions

Explain the etl program with few examples.

548


How to update source definition?

634


What are roles and groups and benefits of using them?

569


What is flashback table ? Advance thanks

1481


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

1559






Explain the use of aggregator cache file?

679


In development project what is the process to follow for an etl developer from day1

1286


what is the hint? how to use it to reduce the query processing in program?

6321


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1594


Differentiate between reusable transformation and mapplet.

579


How to handle decimal places while importing a flatfile into informatica?

727


Design a mapping to load the cumulative sum of salaries of employees into target table?

900


What are the new features of informatica 9.x in developer level?

568


Differences between connected and unconnected lookup?

610


How we can create indexes after completing the load process?

615