we hava a flat file having more than 1000 records and two
targets. i have to write first half of the rows into first
targets and next half of rows into second target. how can i
do in informetica??
Answer Posted / naveen
simple, use the router transformation. when u r able to
find which is the first half and which is the second half
exactly
But how to find ?
thats the second question , the clue is we can use sorter ,
aggregator , router itself to do this job.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between round-robin partitioning and hash partitioning?
What is etl process. How many steps etl contains explain with example?
Mention few test cases and explain them?
list and discuss two approaches for updation of target table in Informatica and how they are different.
Identifying the bottlenecks in various components of Informatica and resolving them.
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
What are the ETL Testing Operations?
When do we analyze the tables? How do we do it?
What are the key benefits of ETL Testing?
how do use session mapping parameters ?(in which transformation)
Two default user groups created in the repository are____and_____.
what is the difference between cubes and package in cognos
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
What is virtual Data Warehousing?
Explain about round-robi?