Hi
If i had source like unique & duplicate records like 1,1,2,3,3,4
then i want load unique records in one target like 2,4 and i want
load duplicate records like 1,1,3,3 then can any body please send
me what is th scnario. my mail i
shek.inform@gmail.com

Answer Posted / dinesh

can u give prepare solution

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can we override a native sql query within informatica? How do we do it?

743


Why do we need informatica?

641


Under what condition selecting sorted input in aggregator may fail the session?

749


Explain how to import oracle sequence into informatica?

675


How to generate or load values in to the target table based on a column value using informatica etl tool.

704






Is there any target staging area in informatica not staging area

2229


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1706


What is the need of etl tools?

714


If informatica has its scheduler why using third party scheduler?

897


Design time, run time. If you don't create parameter what will happen

1515


What are the limitations of joiner transformation?

746


Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

644


what is the complex transformation you used in informatica

2286


Briefly define reusable transformation?

723


What is InformaticaPowerCenter?

786