Interested to Buy Any Domain ? << Click Here >> for more details...
how remove 1st 3 records & last 3 records in informatics
- 4 Answers
- 9598 Views
- TetraSoft, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / venky
after sq transformation use exp transformation in that add
one port,and take seq generator trans and its properties
reset is enable,and link to the port in exp trans,after
that take filter trans and condition port>3,after that use
sorter trans in that take port desc,after that take exp
trans and create another new port,after that take seq gen
trans in properties resert as enable and link to the new
port,afer that use filter trans condition new port>3 and
connect to target.
this is the process u can do u wil get the result.pls try it
correctly
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / gyana
yes..very nice question
---------------------------
after SQ take two pipeline::::one to find 1st 3 record and another to find last 3 record
------------------------------------------
(1) from SQ connect an expression and into that expression connect a sequence generator to generate sequence.
After expression put a filter t/r (seq>=4) and pass to one target instance(T1)
(2) from SQ connect an expression and into that expression connect a sequence generator to generate sequence.
now take a RANK t/r and set the property as(bottom performer,rank on port SEQ,NUMBER OF rank=3).connect that to second target instance (T2)..it will give u last 3 records..
if any wrong pls send me mail......(gyana.informatica@gmail.com)
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / shaik
if i don't want to change the order of source data,then how
can we perform.....
| Is This Answer Correct ? | 0 Yes | 2 No |
2 pipelines,1st pipeline sorter t/r ascending order then
rank t/r top3
2nd pipeline sorter decending order then rank top3 t/r
| Is This Answer Correct ? | 2 Yes | 7 No |
how the server recognises , if the session fails after loading the 100 records in to the target
Define enterprise data warehousing?
Explain pushdown optimization and types in informatica
what is the size of u r project? and what is the size of source file?
permutations of mapplet
Are there any types of Dynamic Caches in informatica
Explain about Informatica server process that how it works relates to mapping variables?
How many types of sessions are there in informatica.please explain them?
Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?
Have you worked with/created Parameter file
1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??
how did u understand business requirement?
Teradata 
