Answer / praveen reddy

THE ABOVE ANS IS WRONG. AGGREGATOR GIVES ONLY RECORD AS
OUT PUT TO NEXT TRANSFORMATION.YOU WILL GET ONLY ONE RECORD
TO ROUTER TRANFORMATION

Answer / jay

SCR-->SQ-->AGGR-----
| |
| v TRG 1
--------->RTR--> /
/ \
SEQ TRG 2

First get the count of records using Aggr t/r
and use this result in router t/r and have
router condition as SEQ < (Count / 2) for TRG 1
and default for TRG 2

Answer / babu

Hi All,

SRC==>SQ==>EXP1==>SRTR==>EXP2==>RTR==>TG1
|| || ||
SEQ1 SEQ2 ==> TG2

EXPEL NATION OF MAPPING
=======================

1.EXP1: ADD ONE OUTPUT PORT AND ASSIGN THE NEXT VAL PORT FROM SEQ1 TO OUTPUT PORT.
i.e: O_SEQ1=SEQ.NEXTVAL
2.SRTR:SORT THE COLUMNS BASED ON THE O_SEQ1 IN DESCENDING ORDER.
3.EXP2:ADD ONE OUTPUT PORT AND ASSIGN THE "NEXT VAL PORT" FROM SEQ2 TO THIS OUTPUT PORT.
i.e:O_SEQ2=SEQ2.NEXTVAL
4.RTR: GRP1(O_SEQ1>=O_SEQ2)
GRP2(O_SEQ1<=O_SEQ2)(DEFAULT GROUP)

Answer / babu

Frnds small change in the above answer..

i.e: GRP1 :O_SEQ1>=O_SEQ2 ,GRP2: O_SEQ1<O_SEQ2
OR
GRP1 :O_SEQ1>O_SEQ2 ,GRP2: O_SEQ1<=O_SEQ2

Answer / phani

https://community.informatica.com/servlet/JiveServlet/showImage/2-61888-1981/Half_Half_Loading_Flatfile.jpg

Answer / sehaj

CREATE A MAPPING VARIABLE WITH AGGREGATION TYPE AS COUNT.
DEFINE ITS INITIAL VALUE AS 0.
THEN IN EXPRESSION CREATE AN OUTPUT PORT.
COUNT-SETCOUNTVARIABLE(VARIABLE NAME).
USE AN AGGREGATOR TO FIND THE TOTAL NO F RECORDS.
IN ROUTER
CREATE TWO GROUPS
IN FIRST GROUP ENTER CONDITION
COUNT<=(TOTAL NMBR F RECORDS)/2
IN SECOND GROUP ENTER CONDITION
COUNT>(TOTAL NUMBER F RECORDS)/2.

SEHAJ....

Answer / sathish

yes aboue mentioned answer is write answer, because aggegater gives total number of records then it passes to router based on that value we cal write a condition in router

Answer / mike

target1
src-->sq-->seq gen-->rtr--> /
\
target 2

drag the source. create an sequence generator
transformation and then pass all the data to router create
two groups in the router transformation pass it to
target...You can give the condition in the router
transformation based on your requirement. if it is like odd
and even...you can use mod function in the router
transformation.
Mod function returns 0 passit to t2 and mod function
returns 1 pass it to t1
hope this works...correct me if i was wrong

What is fact table? Explain the different kinds of facts.

0 Answers  

Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks

1 Answers   IBM,

Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?

2 Answers   TCS,

Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.

2 Answers   CTS,

what is mapping optimization? wat are the techniques for tat

2 Answers  

How to generate sequence numbers using expression transformation?

0 Answers   Informatica,

What is the benefit of partitioning a session?

0 Answers  

can u apply SCD2 on flat file tgt? if yes wat is the procedure?

3 Answers   Deloitte,

insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files

1 Answers  

in static and dynamic which one is better

2 Answers  

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

0 Answers  

scd methodology?

2 Answers