Interested to Buy Any Domain ? << Click Here >> for more details...
How we can get unique records into one target table and
duplicate records into another target table??
- 11 Answers
- 40755 Views
- Deloitte, IBM, iGate, I also Faced
- E-Mail Answers
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
What is rank index in rank transformation?
What are the different types of repositories created using informatica?
Where are the source flat files kept before running the session?
can we override a native sql query within informatica? Where do we do it?
Why do we need informatica?
Explain sessions?
How would you join a node to the already existing domain?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
How might one distinguish in the case of mapping is right or not without associating session?
How do you convert single row from source into three rows into target?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Explain how many types of dimensions are available in informatica?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Where is metadata stored?
