Interested to Buy Any Domain ? << Click Here >> for more details...
my source like dis
10,asd,2000
10,asd,2000
10,asd,2000
20,dsf,3000
20,dsf,3000
20,dsf,3000
like dis and my requirement is first record is inserted into
first target and duplicates of first record is inserted into
second target ...like dis way ...?
how to achieve dis?
- 4 Answers
- 9564 Views
- Mind Tree, Polaris, I also Faced
- E-Mail Answers
Answer Posted / chandra
take 2 agg Trs after SQ and drag all the ports to both the
AGG Trs and enable group by for all ports for one AGG and
take one output port in second AGG ..,in that take count(no)
then take filter and write condition as count(no)>1
SQ---->AGG(enable all ports group by)-->Tar1
---->AGG(count(no))-->FIL(count(no)>1)--->Tar2
| Is This Answer Correct ? | 11 Yes | 8 No |
Post New Answer View All Answers
what is diff b/t sorter t/r and agg have the option sorter property...
What the difference is between a database, a data warehouse and a data mart?
Implementation methodology
What is a code page?
what is the size of u r source(like file or table)?
list out all the transformations which use cache?
Define sessions in informatica etl?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What are 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?
Explain what are the different versions of informatica?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Global and Local shortcuts. Advantages.
What are the different clients of powercenter?
What are the differences between oltp and olap?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
