wt is informatica file watch timers
in aflat i want to get the first record and last record how
could i.
- 1 Answers
- 8210 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 we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?
If informatica has its scheduler why using third party scheduler?
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
what is meant by lookup caches?
2 Answers Cap Gemini, Informatica,
In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?
What are the different types of Type2 dimension maping?
Why use the lookup transformation ?
how can one eliminate dupliacte data with out using distinct option?
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2. what is the procedure and whar t/r's are involved and what is the mapping flow
wht target override?wht advantages it has compare to target update?
Why we require dwh in particular projects?
Which version configuration tool used in ur project?
Teradata 
