Interested to Buy Any Domain ? << Click Here >> for more details...
i have one source 52 million records i want target only 7
records ?how wil you do what logic to implement?
- 7 Answers
- 13846 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / sameer
If ur source as a flat filemail then we uses first expression transformation and we write expression v1=v1+1 and one output port o1=v1 then after filter transformation and in there filter conditions just write o1 <=7 But if ur source as a relational source then we write select * from table-name
Where rownum <=7
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do you promote a non-reusable transformation to reusable transformation?
Explain the difference between mapping parameter and mapping variable?
Reusable transformation and shortcut differences
How do you load only null records into target?
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 one identify whether mapping is correct or not without connecting session?
In which transformation you cannot drag ports into it?
What is the surrogate key?
What are data-driven sessions?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is domain and gateway node?
What is blocking transformation?
What are the measure objects?
What is difference between a gateway node and worker node?
How to create or import flat file definition in to the warehouse designer?
