Interested to Buy Any Domain ? << Click Here >> for more details...
in my source table i want to delete first and last records and
load in between records into target? how can it possible?
- 3 Answers
- 9812 Views
- HCL, Thomson Reuters, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / venkatesh
the flow will be like this
sequence generetor
|
source--->sq--->aggrigator---->filter--->target
generate sequence number using the sequence generator
connect it to the aggrigator and the flow from sq.group by
sequence num and create two o/p ports
1)min(seqnumber)
2)max(seqnumber)
in filter write the condition as
seqnumber<>min AND max
connect the required ports to the target
u will get the required o/p
| Is This Answer Correct ? | 17 Yes | 7 No |
Answer / mithilesh kumar rai
AGGREGATER
SQ -> JOINER > EXP >UPDST > TGT
SEQ GEN EXPRESSION
AGGREGATE: DON'T SELECT ANY GROUP BY PORT IT WILL PASS LAST.
EXP:TAKE SEQ BEFORE EXPRESSION
JOINER : JOIN AGGREGATOR AND EXPRESSION BASED ON CONDITION
DUMMY(VALUE=1)=DUMMY(VALUE=1)
EXP: OUTPUT_PORT: IIF(NEXTVAL=1 AND EMPID(EXP)=EMPID(AGGT),1,0)
UPDATE_STRATEGY: IIF(OUTPUT_PORT=1,DD_REJECT,DD_INSERT)
let me know if u r facing any problem(8147922210)
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / davankumar
In the aggregator t/r we have aggregate functions first and
last.with these we have to calculate.
| Is This Answer Correct ? | 3 Yes | 11 No |
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?
Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?
What is A cache?
How can you display only hidden files in UNIX
I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?
what is casual dimension?
can any one explain me about junk dimension
WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?
Informatica settings are available in which file?
my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.
Teradata 
