in my source table i want to delete first and last records and
load in between records into target? how can it possible?
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 |
Why do you use Mapping Parameter and mapping variable?
what is fact table?
SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that
Write the program through which the records can be updated?
What is target load order?
What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .
What is Data Caches size?
What is difference between maplet and reusable transformation?
Is snow flake or star schema used? If star schema means why?
tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?
source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?
What is the need of etl tools?