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
- 13826 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
Define mapping and session?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is the maplet?
Explain pushdown optimization $pushdownconfig parameter - informatica
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
server hot-ws270 is connect to Repository B. What does it mean?
In development project what is the process to follow for an etl developer from day1
What is meant by pre and post session shell command?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is option by which we can run all the sessions in a batch simultaneously?
how to load dimension table and fact table. plz tell me the steps.
What are the new features of informatica 9.x in developer level?
What are the different options available for update strategy?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
