suppose i have 1000 records and i want to load half of the
record in target 1 and half in target2.how u'll do?
Answers were Sorted based on User's Feedback
Answer / koti
add seq generator to target. and make a look up to target..
then SQ--> Expr--> add two ports in expr. and define the
conditions as iif(sno<500,'true','false')-->router transf.
--> target and instance of target.
definetly it can works like SCD!
Is This Answer Correct ? | 3 Yes | 1 No |
SQ--->AGG SEQ
SOURCE ----->JOINER---->ROUTER---->TARGET1 AND TARGET2
SQ--->EXP
HERE AGG:1. CT---[O]--->COUNT(EMPNO)
2. NEWPORT---[O]--->1
EXP:1.NEWPORT----[O]---->1
JOINER:NEWPORT(EXP)=NEWPORT(AGG)
ROUTER: GROUP1--->NEXTVAL<=ROUND(CT/2)
GROUP2--->NEXTVAL>ROUND(CT/2)
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / ramesh
src--->Exp--->Seq--->Rtr---->tgt
in sequence generator we will get a key and in rtr we will
mention condition
Is This Answer Correct ? | 3 Yes | 2 No |
SQ---->AGR---->RTR---->TGT
SEQ--->RTR
1) Pass all records to Agr
In AGR take count port ion taht give count(empno)
2)Next create SEQQUENCE GENERATOR connect nexval to router
3) Int RTR Create one Group called 1st half
In that give nextval<=count/2
4) Connect to TGTs from 2 groups (1st half and Default)
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / sarat
Method Automated : Use an Unconnected lookup to count the SRC no. of records, and use it in the RTR.
Method Manual : Check COUNT(*) manually and use it in RTR( Not appreciate)
If Agg is used, one record gets loaded in one table only
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / abhishek kumar
in aggregator---
record(field) group by
total_record <- count(record)
router---
condition1 <- (total_record)/2
default
send to target
condition1 to target first and
default to target second.
Is This Answer Correct ? | 1 Yes | 4 No |
Answer / mike
src-->source qual--->exp--->router--->target
based on the conditions we can use other trn's
correct me if i was wrong
Is This Answer Correct ? | 7 Yes | 11 No |
Answer / sandipan pal
at frist lode it to terget 1 after the transection is completed the lode it to terget 2.........
Is This Answer Correct ? | 2 Yes | 11 No |
What are the data movement modes in informatica?
What is souce qualifier transformation it is active or passive
What is junk dimention?
what is degenerated dimension?
what is flat file override?
Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?
I have source like this 1:2;3. so i want to load the target as 123
What is a surrogate key?
How many ways you create ports?
Why filter transformation is an active one?
What is repository manager?
How will u pas the data with out debugger?