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.........

scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS

1 Answers  

Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?

2 Answers  

how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.

6 Answers   CTS, Symphony,

Define the various join types of joiner transformation?

0 Answers  

What is confirmed fact in dataware housing?

2 Answers   Hewitt, TCS,

What are the steps involved in the migration from older version to newer version of Informatica Server?

0 Answers  

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

0 Answers   TCS,

Performance tuning( what you did in performance tuning)

0 Answers   Infosys,

To achieve the session partition what r the necessary tasks u have to do?

1 Answers  

how many ways can we implement SCD2?

4 Answers   IBM, TCS,

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000

1 Answers   HP,

What is persistent lookup cache?

0 Answers