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
- 13726 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
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Name the different lookup cache(s)?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is the difference between STOP and ABORT options in Workflow Monitor?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Why update strategy and union transformations are active? Explain with examples.
server hot-ws270 is connect to Repository B. What does it mean?
What do you mean by worklet?
Define enterprise data warehousing?
What is sequence generator transformation in informatica?
How to Create a folder using pmrep command?
Write the prerequisite tasks to achieve the session partition?
How we can create indexes after completing the load process?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What does refresh system mean, and what are its distinctive choice?
