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
Answer Posted / 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 |
Post New Answer View All Answers
Which transformation is needed while using the Cobol sources as source definitions?
How are the sources and targets definitions imported in informatica designer?
How do you take back up of repository?
Do you find any difficulty while working with flat files as source and target?
Can anyone tell me the new features in Informatica 9 Version?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Explain sessions?
What is a transaction control transformation?
Separate from a database, an information bazaar, and an information stockroom?
On which transformations you created partitions in your project?
Is there any target staging area in informatica not staging area
What is the difference between Active and Passive transformation?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM