wt is informatica file watch timers
in aflat i want to get the first record and last record how
could i.
- 1 Answers
- 8225 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 |
what is mapping override?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?
server hot-ws270 is connect to Repository B. What does it mean?
What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?
Differentiate between reusable transformation and mapplet.
without update strategy how to insert &update?
How big was your fact table
update strategy transformation in informatica
What is the difference between a shortcut of an object and copy of an object? Compare them.
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
How to go to the older version for a mapping?
Teradata 
