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
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
How to extract sap data using informatica?
What do you mean incremental aggregation?
How to partition the Session?
Is it possible to create multiple domains on a single Informatica server?
what is diff b/t sorter t/r and agg have the option sorter property...
What is a stored procedure transformation?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What do think which one is the better joiner or look up?
What are ETL Tools?
What are the types of lookup transformation?
What is meant by lookup transformation? Explain the types of lookup transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is meant by a domain?