How to send duplicates to one target and unique rows to one
target?target is empty
Answer Posted / venkat
S->S.Q->Aggr->Rtr->T1
->T2
Where Aggr take group by option
Rtr group1 condition reccount>1..........>T1
Rtr default group to....................>T2
T1 records are unic records
T2 records are duplicate records
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Explain sessions?
Define update strategy?
Enlist the tasks for which source qualifier transformation is used.
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Explain pushdown optimization and types in informatica
What are the advantages of using informatica as an etl tool over teradata?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
How to extract the informatica rejected data?
What is a filter transformation and why it is an active one?
What are the types of schemas we have in data warehouse.
what is degenerated dimension?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
what is diff b/t sorter t/r and agg have the option sorter property...
Explain sessions and how many types of sessions are there?