Interested to Buy Any Domain ? << Click Here >> for more details...
in informatica,if i have some no.of records,if i want 1st
and 10th records..what will be the method to use?
- 11 Answers
- 34321 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / sujana
i think v shud use FIRST and LAST functions in aggregator..
| Is This Answer Correct ? | 0 Yes | 8 No |
Post New Answer View All Answers
What are active transformations.
What is transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Define mapping and session?
Why update strategy and union transformations are active?
What will be the approach?
What is status code in informatica?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Enlist few areas or real-time situations where informatica is required.
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is repository manager?
Is it possible to use a client with different version than that of its Informatica server?
How do you promote a non-reusable transformation to reusable transformation?
