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
- 12139 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
difference between repository database and repository service?
What is enterprise data warehousing?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is domain in terms of informatica?
tell me the rules and responsblites in our project(my project is development)
Write the unconnected lookup syntax and how to return more than one column.
What is the benefit of session partitioning?
How union transformation is used?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
if we have a delimiters at unwanted places in a flat file how can we over come those.
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What are the restrictions of union transformation?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
