how to get flatfile containg 10 records half records one
target another half another target
Answer Posted / mahipal reddy
first create a sequence to those 10 records n using filter
or router transformation filter first 5 columns n load into
target similarly remianing 5 records.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are active transformations.
Explain the types of transformations?
design of staging area?
What are the advantages of using informatica as an etl tool over teradata?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What differs when we choose the sorted input for aggregator transformation?
Where are the source flat files kept before running the session?
Suppose we do not group by on any ports of the aggregator what will be the output?
What all are steps in up gradation of Informatica server?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is informatica? Why do we need it?
What is the need of an ETL tool?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is meant by LDAP users?