Interested to Buy Any Domain ? << Click Here >> for more details...
How you load distinct records into one target and duplicate
records into another target?
- 3 Answers
- 16445 Views
- Mphasis, I also Faced
- E-Mail Answers
Answer Posted / shaik
Create a mapping with two targets.
> Create an Aggregator transformation and group it on the
distinct values and load it into Target1.
> Load the data directly in to Target2 since the source
have duplicates it will load all the duplicates.
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
Clarify the utilization of aggregator cache record?
Explain pushdown optimization $pushdownconfig parameter - informatica
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is rank transformation in informatica
Explain the mapping variable usage example in informatica
How are indexes created after completing the load process?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What are the mapping parameters and mapping variables?
What is mapping debugger?
How to load a Dimension ? and how to load a fact table?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
write a query to retrieve the latest records from the table sorted by version(scd)
what is the size ur source like(file system or database)? how many record daily come u r banking project?
