Interested to Buy Any Domain ? << Click Here >> for more details...
How to extract original records at one target & Duplicate
records at one target?
- 12 Answers
- 22668 Views
- I also Faced
- E-Mail Answers
Answer Posted / krishnakanth.ch
yes... add a new column in the sql override by calculating
the count(*) to get how many times the record is repeating.
Using Router we can seperate them into two different
targets.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How you prepared reports for OLAP?
How to create the source and target database connections in server manager?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
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
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Explain what is informatica metadata and where is it stored?
update strategy transformation in informatica
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Clarify the aggregator change?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is dimensional table?
Design a mapping to load a target table with the following values from the above source?
How many ways are there to do 'remove duplicate records in informatica'?
What is aggregator transformation in informatica?
