my source having the records like

ram 3
sam 5
tom 8

and i want to load into target like ram record 3 times,sam
record 5 times, tom record 8 times

Answer Posted / james

Hi Guys,

we can get the desired result set using Java t/r applying
for loop.

Please let me know if you have any suggestions.

Thanks,
James.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the meaning of decode in informatica?

650


What are ETL Tools?

669


what is song in infrmatica...?

1679


What is a passive transformation?

646


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 ?

1745






I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1088


How can one identify whether mapping is correct or not without connecting session?

883


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

606


What is informatica metadata and where is it stored?

591


What is meant by active and passive transformation?

587


Can we create a node as a gateway node and the same node can be assigned to a grid?

641


which one is better performance wise joiner or look up

630


What are the types of schemas we have in data warehouse.

533


Partition, what happens if the specified key range is shorter and longer

2031


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

600