How we can get unique records into one target table and
duplicate records into another target table??
Answer Posted / haaris
If the source is RDMS, then you can write analytic function in the select statement to assign count to each row. And use this count column to route the records to respective target.
If the source is a flat (this is generally asked in interviews), then you can use aggregator to assign count to each row after grouping based on the key and use joiner to join back to source records that way all the rows coming from the SQ will have respective counts. Use router to route them to respective targets.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Have you worked with/created Parameter file
What are the guidelines to be followed while using union transformation?
How can you generate reports in informatica?
How to convert multiple rows to single row (multiple columns) in informatica
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Global and Local shortcuts. Advantages.
What is Cognos script editor?
What are active transformations.
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
What are the uses of etl tools?
is it possible to index the data in cache of lkp transformation ?
How to update or delete the rows in a target, which do not have key fields?
Where is metadata stored?
Which version configuration tool used in ur project?
Informatica settings are available in which file?