Interested to Buy Any Domain ? << Click Here >> for more details...
How to list Top 10 salary, without using Rank Transmission?
- 16 Answers
- 44561 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / giri
First use sorter with salary based and sequent generator next filter transformation
Sorter(salary desending order)-----> Sequent genarator
--------->Filter(seq<=10)
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
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?
What are mapplets? How is it different from a Reusable Transformation?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Mention few advantages of router transformation over filter transformation.
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is rank index in rank transformation?
Under which circumstances, informatica server creates reject files?
Can we create two repositories on same database instance in oracle?
How can repository reports be accessed without sql or other transformations?
How to use procedural logic inside infromatica?
What is intricate mapping?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
How can a transformation be made reusable?
Is it possible to use a client with different version than that of its Informatica server?
