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
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
Make a note of the quantity vaults made in informatica?
Why do you use Mapping Parameter and mapping variable?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What are the types of schemas we have in data warehouse.
Explain the scenario which compels informatica server to reject files?
Where can we find the throughput option in informatica?
What is the function of union transformation?
What is the difference between informatica 7.0 and 8.0?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
what is size of u r database?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Can anyone tell me the new features in Informatica 9 Version?
What is the benefit of partitioning a session?
What is lookup transformation?
What is the command used to run a batch?