Interested to Buy Any Domain ? << Click Here >> for more details...
How to send duplicates to one target and unique rows to one
target?target is empty
- 9 Answers
- 31041 Views
- Amazon, IBM, Wipro, I also Faced
- E-Mail Answers
Answer Posted / shiva
s-->sq-->agg-->rtr-->tgt1
'--> tgt2
in aggr take two ports count(*)=1
count(*)>1 take group by on column
send this to rtr(create 2 groups in rtr)
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is an expression transformation in informatica?
How do you load alternate records into different tables through mapping flow?
can we override a native sql query within informatica? Where do we do it?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How to generate or load values in to the target table based on a column value using informatica etl tool.
What could be the possible resons of locks by user?
What are the performance considerations when working with aggregator transformation?
How an expression transformation differs from aggregator transformation?
How to implement security measures using repository manager?
What is the reusable transformation?
What is the procedure for creating independent data marts from informatica 7.1?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
How can we use batches?
