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 / 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 |
Post New Answer View All Answers
Explain sessions?
Sequence generator, when you move from develoment to production how will you reset
What are the new features of Power Center 5.0?
design of staging area?
Enlist the advantages of informatica.
What are the types of data warehouses?
Explain the tuning lookup transformation - informatica
Explain direct and indirect flat file loading (source file type) - informatica
Parameter and variable differences
What is exclusive and normal mode for repository services?
What is aggregate cache in aggregator transformation?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
explan ur project architecture?
Please let me know how to make encryption and decryption with example?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?