there is a product table
prodid prodname price
100 cinthol 10
101 hamam 10
102 neem 20
103 cake 30
in the above table the price of some products are
duplicated and some product prices are distinct we want to
push the duplicated prices to one target and non-duplicated
prices to other target without using expression and
sequence generator transformation
Answer Posted / ankit kansal
Use a Rank Transformation and calculate rank on the group by basis on price and then using any router route your data to two different outputs.
http://deepinopensource.blogspot.in/
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the new features of informatica 9.x developer?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is session task and command task?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
How many ways a relational source definition can be updated and what are they?
Explain joiner transformation in informatica
How do we call shell scripts from informatica?
What is a filter transformation and why it is an active one?
Explain your project of banking domian.
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is dimensional table? Explain the different dimensions.
What is event and what are the tasks related to it?
What are the differences between oltp and olap?
Plz can any one say me how to get the informatica certification materials and dumps
Which version configuration tool used in ur project?