Interested to Buy Any Domain ? << Click Here >> for more details...
i have flat file it contains 'n' number of records, i need
to send half of the records to one target table and
Remaining half to another target table: pls full details
- 8 Answers
- 18171 Views
- L&T, TCS, UnitedHealth Group, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 5 Yes | 1 No |
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
| Is This Answer Correct ? | 9 Yes | 7 No |
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)
| Is This Answer Correct ? | 2 Yes | 0 No |
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
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / phani
https://community.informatica.com/servlet/JiveServlet/showImage/2-61888-1981/Half_Half_Loading_Flatfile.jpg
| Is This Answer Correct ? | 0 Yes | 0 No |
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....
| Is This Answer Correct ? | 0 Yes | 1 No |
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
| Is This Answer Correct ? | 1 Yes | 5 No |
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
| Is This Answer Correct ? | 3 Yes | 13 No |
What is a filter transformation and why it is an active one?
How you load distinct records into one target and duplicate records into another target?
How can we get multiple output values using an unconnected lookup transformation?
difference between shortcut and reusable transformation?
what is the Default Source Option For Update Strategy Transformation?
what is the difference between repository & Intergration service
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?
Can anyone please distinguish what is Inner join and Outer join
How many ways are there to do 'remove duplicate records in informatica'?
what is the process we used in joiner transformation,there is no matching column in sources?
How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?
Explain about perform recovery?
Teradata 
