Answer Posted / lalamaheshkumar
small correction for above ..
Hi for the above question you are going to get the suresh
record twice if you select rank as three (3) . to get the
distinct records , in source qualifier put a distinct
clause in the query .. then you will get the correct result.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
what are factless facts? And in which scenario will you use such kinds of fact tables.
What are the features of complex mapping?
How to do unit testing in informatica? How to load data in informatica ?
Sequence generator, when you move from develoment to production how will you reset
What is the benefit of partitioning a session?
Explain Dataware house architecture .how data flow from intial to end?
What could be the possible resons of locks by user?
What is dimensional table? Explain the different dimensions.
How to use pmcmd utility command?
What is the Process to creating lookup transformation in informatica
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Did u used latest transformations of 8.6.0? for what?
What are the main features of Oracle 8i with context to datawarehouse?