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
- 18511 Views
- L&T, TCS, UnitedHealth Group, Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Is there any target staging area in informatica not staging area
What is the difference between router and filter?
What is the format of informatica objects in a repository?
Explain load alternative records / rows into multiple targets - informatica
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
How we can create indexes after completing the load process?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
In how many ways we can create ports?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What is the scenario which compels informatica server to reject files?
Differentiate between a database and data warehouse?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is domain and gateway node?
What is an expression transformation in informatica?
