suppose i have 1000 records and i want to load half of the record in target 1 a

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

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?

Question Posted / minisweet85

9 Answers
13100 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.h..

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

suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.h..

Answer / gvk

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

suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.h..

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

suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.h..

Answer / shankar

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

suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.h..

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

suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.h..

Answer / sanjay

By using the Router transformation we can load half of the
record in target 1 and half in target2.

src-->source qual--->Seq Generator(If
needed)--->router--->targets

Is This Answer Correct ?

1 Yes

3 No

suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.h..

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

suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.h..

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

suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.h..

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

Post New Answer