Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

Answers were Sorted based on User's Feedback



i have flat file it contains 'n' number of records, i need to send half of the records t..

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

i have flat file it contains 'n' number of records, i need to send half of the records t..

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

i have flat file it contains 'n' number of records, i need to send half of the records t..

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

i have flat file it contains 'n' number of records, i need to send half of the records t..

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

i have flat file it contains 'n' number of records, i need to send half of the records t..

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

i have flat file it contains 'n' number of records, i need to send half of the records t..

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

Is This Answer Correct ?    0 Yes 1 No

i have flat file it contains 'n' number of records, i need to send half of the records t..

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

i have flat file it contains 'n' number of records, i need to send half of the records t..

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

Post New Answer

More Informatica Interview Questions

How can you differentiate between powercenter and power map?

0 Answers  


What is Micro Strategy? Why is it used for?

5 Answers   Infosys,


What is predefined event?

1 Answers  


What are the types of metadata that stores in repository?

2 Answers  


Explain the features of connected and unconnected lookup.

0 Answers  


following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000

5 Answers   Wipro,


what is workflow varible

1 Answers   HP,


How do you create single lookup transformation using multiple tables?

6 Answers   TCS,


How can we remove the duplicates from flat file source?

0 Answers  


In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?

6 Answers  


What is an expression transformation in informatica?

0 Answers  


What is the use of an aggregator cache file?

0 Answers  


Categories