i have one source 52 million records i want target only 7
records ?how wil you do what logic to implement?
- 7 Answers
- 11737 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
What are Dimensional table?
What is the sequence generator transformation in informatica?
Explain in detail scd type 2 through mapping.
What is an active transformation?
I have a flat file, want to reverse the contents of the flat file
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
How can repository reports be accessed without sql or other transformations?
How do you set a varible in incremental aggregation
expain about the tune parameters?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Why update strategy and union transformations are active?
Explain informatica architecture - version 8 / 9
How to differentiate between the active and passive transformations?
Describe data concatenation?
