Interested to Buy Any Domain ? << Click Here >> for more details...
wt is informatica file watch timers
in aflat i want to get the first record and last record how
could i.
- 1 Answers
- 8969 Views
- CTS, I also Faced
- E-Mail Answers
Answer / bsgsr
i believe this should work.
1) use the first and last functions of aggregate t/tion.
2) use the top option and 1 rank using rank t/tion
similarly last option and 1 rank to get only the first
and lst records.
3) else connect the flat file to filter t/tion. create new
port in filter name it s_no and connect the nextval port of
s.gen and write the contion (assume the file contains 100
records) like s_no=1 or s_no=100
| Is This Answer Correct ? | 5 Yes | 1 No |
If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is the difference between a connected look up and unconnected lookup?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Explain constraint based loading in informatica
How will you check the bottle necks in informatica? From where do you start checking?
What did you do in source pre load stored procedure
select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
In which scenario did you used pushdown optimization?
What are steps to follow Informatica migration from 7x to 8x? Pls Explain...
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What are variable ports and list two situations when they can be used?
Teradata 
