Interested to Buy Any Domain ? << Click Here >> for more details...
i have f;latfile source. i have two targets t1,t2. i want to
load the odd no.of records into t1 and even no.of recordds
into t2. what is the procedure and whar t/r's are involved
and what is the mapping flow
- 4 Answers
- 11987 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / sreekar
Hi,
Steps:-
1.Load ur source table into source analyzer.
2.generate the target tables.
3.in the maping designer take 2 filter transformations and
write these queries in each of the filter transformations
for even no of records:- select * from <tablename> where
(rowid,1) in (select rowid, mod(rownum,2) from <tablename>)
for odd no of records:- select * from <tablename> where
(rowid,0) in (select rowid, mod(rownum,2) from <tablename>)\
4. connect the output ports of this transformation to their
respective output tables.
Note:-
send your responses to suriaslesha_sreekar@yahoo.co.in
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
How we can create indexes after completing the load process?
What is Cognos script editor?
Sequence generator, when you move from develoment to production how will you reset
Write the different tools in the workflow manager?
what is size of u r database?
What is joiner transformation in informatica?
What is the Process to creating lookup transformation in informatica
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is the sql query overwrite in source qualifier in informatica
What are the different ways to implement parallel processing in informatica?
Explain about cumulative Sum or moving sum?
Design a mapping to load a target table with the following values from the above source?
What is sq transformation?
scenario where i can use only concurrent execution of workflow.
How might you approve all mappings in the archive all the while?
