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
Whats there in global repository
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?
Explain joiner transformation in informatica
What differs when we choose the sorted input for aggregator transformation?
What are the transformations that are not supported in mapplet?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are active transformations.
Write the unconnected lookup syntax?
What does update strategy mean, and what are the different option of it?
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 ?
What is data movement mode in Informatica and difference between them?
What is the format of informatica objects in a repository?
Explain why we use partitioning the session in informatica?
Explain the types of transformations?
What is dimensional table?