i have one source 52 million records i want target only 7
records ?how wil you do what logic to implement?
Answer Posted / chandra
you create a Rownum port in target system and use the Ex/T u create o_port in Expression edition give the logic is Rownum<=7
Its Right Or Wrong Please...........Tell me
Regards
Chandra
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Explain what transformation and how many are there in informatica?
What is session task and command task?
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?
What are the new features of informatica 9.x developer?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is a stored procedure transformation?
Do you find any difficulty while working with flat files as source and target?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What are the features of complex mapping?
Partition, what happens if the specified key range is shorter and longer
What is domain and gateway node?
lookup transformation with screenshots
What do you mean by worklet?
How do you set a varible in incremental aggregation