Interested to Buy Any Domain ? << Click Here >> for more details...
How to eliminate duplicates in FF and oracle both
- 3 Answers
- 7231 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / ravindra.15aug
In RDBMS we can write sql queary in Source qualifer by
using rowid, in sorter by using select distinct option, In
aggregator by using groupby, in Rank by using groupby.
In FF level also we can do except sql queary in source
qualifier.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is workflow? What are the components of workflow manager?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What are junk dimensions?
What is meant by lookup transformation? Explain the types of lookup transformation?
Enlist the various types of transformations.
How to load the data from a flat file into the target where the source flat file name changes daily?
what is unit testing?tell me proceedure
How many ways a relational source definition can be updated and what are they?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What do mean by local and global repository?
What are the types of lookup transformation?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
what is the -ve test case in your project.
Write the advantages of partitioning a session?
What is a node in Informatica?
