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
- 12193 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
What is the fact table?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
how we can load rejected record's at run time?(not through bad files)
How to configure mapping in informatica?
Which version configuration tool used in ur project?
What is difference between a gateway node and worker node?
How to generate or load values in to the target table based on a column value using informatica etl tool.
how to load dimension table and fact table. plz tell me the steps.
What is InformaticaPowerCenter?
How to load last n records of file into target table - informatica
What is the function of look up transformation?
Different sorts of metadata that stores in the storage facility?
Differentiate between router and filter transformation?
How can informatica be used for an organization?
explain about unit testing? in real time?
