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!

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)

Answer / ramesh

src--->Exp--->Seq--->Rtr---->tgt
in sequence generator we will get a key and in rtr we will
mention condition

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)

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

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

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.

Answer / mike

src-->source qual--->exp--->router--->target

based on the conditions we can use other trn's

correct me if i was wrong

Answer / sandipan pal

at frist lode it to terget 1 after the transection is completed the lode it to terget 2.........

i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four

3 Answers  

how can one come to know wether the records loak into the target if we use update strategy

1 Answers   Wipro,

i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no

4 Answers   HCL,

Define enterprise data warehousing?

0 Answers  

Can you copy the session to a different folder or repository?

1 Answers  

What is limitations of truncate and load option

1 Answers   Cap Gemini,

What does update strategy mean, and what are the different option of it?

0 Answers  

What are the out put files that the informatica server creates during the session running?

2 Answers  

After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?

6 Answers  

in static and dynamic which one is better

2 Answers  

i have 2 mapings for this 2 mapings i want use only one lookupt/r how?

3 Answers   Wipro,

How can we update a record in the target table without using update strategy?

0 Answers